 | |
#11
 
| |||
| |||
|
Re: Date format -
08-18-2008
, 04:52 PM
|
I am looking at moving some old database systems to MySQL and I am currently working on data loading using mysqlinport. I have an issue with dates as all the data that is coming my way has dates in DD/MM/YYYY. the load routines look to only accept it in YYYY/MM/DD. Is there anyway of telling the routines to use the European date format? Would be nice if it could display dates in the format as well. |
reformat it to/from internal format from/to human format. While you're
at it make it flexible, so it allows any delimiter rather than just the
slash, allows month names as well as month numbers, and makes some sort
of guess about what 2-digit years mean.
#12
| |||
| |||
|
|
I am looking at moving some old database systems to MySQL and I am currently working on data loading using mysqlinport. I have an issue with dates as all the data that is coming my way has dates in DD/MM/YYYY. the load routines look to only accept it in YYYY/MM/DD. Is there anyway of telling the routines to use the European date format? Would be nice if it could display dates in the format as well. |
reformat it to/from internal format from/to human format. While you're
at it make it flexible, so it allows any delimiter rather than just the
slash, allows month names as well as month numbers, and makes some sort
of guess about what 2-digit years mean.
#13
| |||
| |||
|
|
I am looking at moving some old database systems to MySQL and I am currently working on data loading using mysqlinport. I have an issue with dates as all the data that is coming my way has dates in DD/MM/YYYY. the load routines look to only accept it in YYYY/MM/DD. Is there anyway of telling the routines to use the European date format? Would be nice if it could display dates in the format as well. |
reformat it to/from internal format from/to human format. While you're
at it make it flexible, so it allows any delimiter rather than just the
slash, allows month names as well as month numbers, and makes some sort
of guess about what 2-digit years mean.
#14
| |||
| |||
|
|
I am looking at moving some old database systems to MySQL and I am currently working on data loading using mysqlinport. I have an issue with dates as all the data that is coming my way has dates in DD/MM/YYYY. the load routines look to only accept it in YYYY/MM/DD. Is there anyway of telling the routines to use the European date format? Would be nice if it could display dates in the format as well. |
reformat it to/from internal format from/to human format. While you're
at it make it flexible, so it allows any delimiter rather than just the
slash, allows month names as well as month numbers, and makes some sort
of guess about what 2-digit years mean.
#15
| |||
| |||
|
|
I am looking at moving some old database systems to MySQL and I am currently working on data loading using mysqlinport. I have an issue with dates as all the data that is coming my way has dates in DD/MM/YYYY. the load routines look to only accept it in YYYY/MM/DD. Is there anyway of telling the routines to use the European date format? Would be nice if it could display dates in the format as well. |
reformat it to/from internal format from/to human format. While you're
at it make it flexible, so it allows any delimiter rather than just the
slash, allows month names as well as month numbers, and makes some sort
of guess about what 2-digit years mean.
#16
| |||
| |||
|
|
I am looking at moving some old database systems to MySQL and I am currently working on data loading using mysqlinport. I have an issue with dates as all the data that is coming my way has dates in DD/MM/YYYY. the load routines look to only accept it in YYYY/MM/DD. Is there anyway of telling the routines to use the European date format? Would be nice if it could display dates in the format as well. |
reformat it to/from internal format from/to human format. While you're
at it make it flexible, so it allows any delimiter rather than just the
slash, allows month names as well as month numbers, and makes some sort
of guess about what 2-digit years mean.
#17
| |||
| |||
|
|
I am looking at moving some old database systems to MySQL and I am currently working on data loading using mysqlinport. I have an issue with dates as all the data that is coming my way has dates in DD/MM/YYYY. the load routines look to only accept it in YYYY/MM/DD. Is there anyway of telling the routines to use the European date format? Would be nice if it could display dates in the format as well. |
reformat it to/from internal format from/to human format. While you're
at it make it flexible, so it allows any delimiter rather than just the
slash, allows month names as well as month numbers, and makes some sort
of guess about what 2-digit years mean.
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.