0

Hi all

I have a table that has a datetime column. What I'm trying to do is select the time only like one does when selecting only the day or month from a date column (eg SELECT day(date))

Can anyone tell me how to get this right. Using the following doesn't work:

SELECT time(datetime)

Edited by Venom Rush: n/a

2
Contributors
2
Replies
6
Views
7 Years
Discussion Span
Last Post by Ezzaral
0

Ok, seems I was being a noob. The above code does work. Can a mod please delete this thread. Thanks.

0

I just marked it solved instead. Perhaps someone searching for how to do this will run across your post and it will help them.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.