TIMESTAMP decimal year format available?

2004-04-07 Thread Pierre Didelon
Hi, I am using mysql and I need to store timestamp. In input I got something like yyy-dddThh:mm:ss, ddd beeing the day of the year! I would like to make the minimun transformation before loading data in database, so I would like to enter the timestamp with a format handling decimal year yyy.ddd

Re: TIMESTAMP decimal year format available?

2004-04-07 Thread Paul DuBois
At 17:34 +0200 4/7/04, Pierre Didelon wrote: Hi, I am using mysql and I need to store timestamp. In input I got something like yyy-dddThh:mm:ss, ddd beeing the day of the year! I would like to make the minimun transformation before loading data in database, so I would like to enter the timestamp