How do I insert values in my table using time fields? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

How do I insert values in my table using time fields?

I have to enter time fields for the table. Please help me with the syntax! https://code.sololearn.com/c1EnjojjP2eY/?ref=app

3rd Aug 2022, 7:03 PM
Knowledge Is Power
Knowledge Is Power - avatar
2 Answers
+ 1
Quarter_Of_Date, Month_Of_Year,Year_Of_Date you do not need, if OrderDate Will be Datetime type. See MySQL Datetime type.
4th Aug 2022, 8:28 PM
Václav Dostál
Václav Dostál - avatar
0
Václav Dostál thank you for your response. I am looking to insert values in these fields. Not sure what to insert as my values
4th Aug 2022, 8:31 PM
Knowledge Is Power
Knowledge Is Power - avatar