how to format the timestamp value

[2001 JI Open Discussion]

By: MohanProint - mohanproint

how to format the timestamp value

2005-03-02 22:45

I have timestamp column in my table. How do i format the timestamp in to readable format in <queryString>.Now i have "DATE_FORMAT(DATE,'%W %M %D %Y') as DATE" to get te date format. I need the readable format mm/dd/yy and time as HH:MM:SS.

 

 

By: ToRaX - torax

RE: how to format the timestamp value

2005-03-03 00:02

Google is your friend... ;-)

http://dev.mysql.com/doc/mysql/de/date-and-time-functions.html

 

 

By: MohanProint - mohanproint

RE: how to format the timestamp value

2005-03-03 01:23

U can for like this format in your <queryString> select NAME,DATE_FORMAT(UPDATE_TIMESTAMP,'%M %D %Y ') as UPDATE_TIMESTAMP from EMPLOYEE </qureyString>

it will give the output in this format March 3rd 2005