RE: Time Column Type problem - indrek siitan - com.mysql.lists.win32

6 messages in com.mysql.lists.win32RE: Time Column Type problem

Hi,

Display on my ASP page: 6/7/00 6:00:00 PM How can I get the time only and no date?

on the other page, instead of

SELECT ..,..,eventtime,..,.. FROM table

do:

SELECT ..,..,DATE_FORMAT(eventtime,'%H:%i:%s'),..,.. FROM table

Rgds, Tfr