Re: how to convert time_t to ANSI SQL format DateTime string(2005-05-02

#1

zlf wrote:

Quote:

Hi,
May anyone tell me how to change datetime with Unix format(Mon May 02
10:09:09 2005) to ANSI SQL format(2005-05-02 10:09:09) or directly convert
time_t to ANSI SQL format string.
I am developing a log program using C++ and Mysql. I want to inserting
time data into a DateTime-type column. Mysql requires datetime with ANSI SQL
format. However ctime ( time_t * time ) returns value like 'Mon May 02
10:09:09 2005'(datetime with Unix format).
thx
zlf

use strftime() which lets you format a date however you want.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: how to convert time_t to ANSI SQL format DateTime string(2005-05-02

mailing.database.mysql-plusplus mailing.database.mysql-plusplus

Re: how to convert time_t to ANSI SQL format DateTime string(2005-05-02 - 05-02-2005 , 11:07 AM