TimeOfDay() returns 1/1/0001

I am using TimeOf Day to retrieve the current time, but it returns something like
1/1/0001 11:33:35 AM

And I use NOW() to return the current Date, but it returns the time also.
How do I get the date only, like 5/23/06 and time only, like 11:33:35 AM
Thanks for help
CochiseCountyAsked:
Who is Participating?
 
raterusCommented:
I believe a datetime type has both a ".Date" and a ".Time" property, that you can use to retrieve only the time you are interested in.

You might also want to look at the .ToShortDateString() and .ToShortTimeString() methods of the DateTime class, these might be what you are looking for.
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.