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
with a format handling "decimal year" yyy.ddd but AFA I understand
the mysql doc, it seems not available?
You understand correctly. Either transform the values before loading
them, or load them into some other kind of column (CHAR?) and perform
some kind of transformation using SQL to get them into the correct
format.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
