MySQL Date and Time Setting to Now

HI Experts,

I have 2 separate fields, pickup_date and pickup_time that I have defined as date and time fields respectively. I would also like to keep these fields separate.

My question is how can I define the default value for the these fields to the current time and current date respectively?

Thank you
APD TorontoAsked:
Who is Participating?
 
matrix8086Commented:
you have the functions CURDATE() and CURTIME()

Best regards!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.