Member Avatar for Venom Rush

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 because: n/a
  • 2 Contributors
  • 2 Replies
  • 173 Views
  • 12 Hours Discussion Span
  • Latest Post Latest Post by Ezzaral
Member Avatar for Venom Rush

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

Member Avatar for Ezzaral

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.