Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
April 19, 2005, 8:09 pm
rate this thread
When I run select now(); or select current_timestamp(), I see the
output like "2005-04-19 02:50:14". By reading the documentation I
thought the the hour value should be in military format namely 14, but
instead I see 02. How can I fix this problem? I have MySQL 4.1.10a
database running on RH 9.0 server.
Re: now() or current_timestamp() and the hours value in time
Read about the DATE_FORMAT() function on this page:
You can force military-style 24-hour format by using the %H or %T format
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum