date format

[Yasaswi Pulavarti]

I have a text file I need to load into MySQL database. In the text
file the date is shown as mm/dd/yyyy format. However I need to enter
the date in MySQL native yyyy-mm-dd format. How can I change
formatting without using substring function?
Thanks,
Yasaswi

 

[Tad McClellan]

I have a text file I need to load into MySQL database. In the text
file the date is shown as mm/dd/yyyy format. However I need to enter
the date in MySQL native yyyy-mm-dd format. How can I change
formatting without using substring function?

What is wrong with the substr() function?


s#(\d\d)/(\d\d)/(\d\d\d\d)#$3-$1-$2#; # untested

 

[Gunnar Hjalmarsson]

I have a text file I need to load into MySQL database. In the text
file the date is shown as mm/dd/yyyy format. However I need to enter
the date in MySQL native yyyy-mm-dd format. How can I change
formatting without using substring function?

s|(\d\d)/(\d\d)/(\d{4})|$3-$1-$2|

 

[Gregory Toomey]

I have a text file I need to load into MySQL database. In the text
file the date is shown as mm/dd/yyyy format. However I need to enter
the date in MySQL native yyyy-mm-dd format. How can I change
formatting without using substring function?
Thanks,
Yasaswi

According to http://dev.mysql.com/doc/mysql/en/Loading_tables.html ,
even the mysql data loader only accepts yyyymmdd.

Write a small Perl script to reformat the dates.

gtoomey

 

[Eric Amick]

I have a text file I need to load into MySQL database. In the text
file the date is shown as mm/dd/yyyy format. However I need to enter
the date in MySQL native yyyy-mm-dd format. How can I change
formatting without using substring function?

MySQL has a STR_TO_DATE function that can do the conversion for you:

STR_TO_DATE('06/12/2004', '%m/%d/%Y')

 

[Eric J. Roode]

(e-mail address removed) (Yasaswi Pulavarti) wrote in

I have a text file I need to load into MySQL database. In the text
file the date is shown as mm/dd/yyyy format. However I need to enter
the date in MySQL native yyyy-mm-dd format. How can I change
formatting without using substring function?
Thanks,
Yasaswi

This is a homework problem, isn't it?

--
Eric
`$=`;$_=\%!;($_)=/(.)/;$==++$|;($.,$/,$,,$\,$",$;,$^,$#,$~,$*,$:,@%)=(
$!=~/(.)(.).(.)(.)(.)(.)..(.)(.)(.)..(.)......(.)/,$"),$=++;$.++;$.++;
$_++;$_++;($_,$\,$,)=($~.$"."$;$/$%[$?]$_$\$,$:$%[$?]",$"&$~,$#,);$,++
;$,++;$^|=$";`$_$\$,$/$:$;$~$*$%[$?]$.$~$*${#}$%[$?]$;$\$"$^$~$*.>&$=`