Mailinglist Archive: opensuse (3464 mails)

[Kai Ponte <kai@xxxxxxxxxxxxxxxx>]

On Wednesday 11 April 2007 09:42:36 am James Hatridge wrote:
> Hi all,
>
> I have records with the date in DD-MM-YYYY, but mysql wants them in
> YYYY-MM-DD. Is there anyway of changing Mysql's format?
>

Um, my suggestion would be to do some kind of CAST or CONVERT. I'm not so 
familiar with MySQL in terms of raw Transact-SQL, but in most cases you can 
do this.

Given a text file (that is your source, right?) you can add as part of your 
INSERT statement something like a part of the string so you can piece it 
together. I don't know if you're using a program (C, PHP) or just SQL. In 
SQL, you would need to perform a lot of manipulation. You'd be better using 
Kate (or Vi) to parse the file yourself.


-- 
kai

Free Compean and Ramos
http://www.grassfire.org/142/petition.asp
http://www.perfectreign.com/?q=node/46
-- 
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
For additional commands, e-mail: opensuse+help@xxxxxxxxxxxx