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)

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

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