|
Home > Archive > SQL Anywhere database > July 2005 > date format, date order
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
date format, date order
|
|
|
| SQL Anywhere 9.0.1.1751
I have a .csv file that is HUGE. It contains dates in the
form of 'mm/dd/yyyy'. I need to import this into a ASA 9
db.
I cannot open this in excel and edit the dates because it
will cut off some data. I'm going to need to do this on the
SQL side.
I've tried...
SET OPTION DATE_ORDER = 'DMY';
SET OPTION DATE_FORMAT = 'MM/DD/YYYY';
....it still will not recognize it. There has to be a way to
do this, right?
| |
| Shuchit 2005-07-28, 3:23 am |
| Steve wrote in news:42e8166b.4653.1681692777@sybase.com:
> I've tried...
>
> SET OPTION DATE_ORDER = 'DMY';
> SET OPTION DATE_FORMAT = 'MM/DD/YYYY';
>
>
Shouldn't that be
SET OPTION DATE_ORDER = 'MDY';
Shuchit
| |
| Steve 2005-07-28, 11:26 am |
| Clever man!
Forgive me, it was late in the day!
> Steve wrote in news:42e8166b.4653.1681692777@sybase.com:
>
>
> Shouldn't that be
> SET OPTION DATE_ORDER = 'MDY';
>
> Shuchit
|
|
|
|
|