|
Home > Archive > SQL Anywhere Feedback > December 2005 > isql datetime format
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 |
isql datetime format
|
|
| Kornilov Alexey 2005-12-30, 7:23 am |
| Allow to set datetime, number formats for isql.exe INPUT TO command.
For example, I need import data from csv file, where datetime values present
in
russian dd.mm.yyyy format. ISQL understand only yyyy-mm-dd.
| |
| Breck Carter [TeamSybase] 2005-12-30, 9:23 am |
| Have you tried changing the value of DATE_ORDER?
On 30 Dec 2005 02:09:21 -0800, "Kornilov Alexey" <alekcey@ukr.net>
wrote:
>Allow to set datetime, number formats for isql.exe INPUT TO command.
>For example, I need import data from csv file, where datetime values present
>in
>russian dd.mm.yyyy format. ISQL understand only yyyy-mm-dd.
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
| Kornilov Alexey 2005-12-30, 8:23 pm |
| Thank You Breck!
DATE_ORDER really work, I don't know about it before.
Happy New Year!!!
|
|
|
|
|