sec_to_time in mysql

by Ramya 2010-09-15 18:12:48

sec_to_time:

Returns the given unix time into to hours, minutes, and seconds. Just use select query to get this format as,

mysql> SELECT SEC_TO_TIME(timestamp);

Tagged in:

1385
like
0
dislike
0
mail
flag

You must LOGIN to add comments