View Single Post

  #4 (permalink)  
Old 05-16-2007
janedunnie@gmail.com
 
Posts: n/a
Default Re: MYSQL TIMESTAMP Format - DOS / Linux

Ah, just figured out that the var's I need are as follows:

mysql> SHOW VARIABLES LIKE "%format%";

.....
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| time_format | %H:%i:%s |
.....

Thanks,
Jane


Reply With Quote