Board index » delphi » SQL Anywhere dates

SQL Anywhere dates

Even if I change the database date format in SQLA to 'mm/dd/yyyy', I can't
seem to get it to recognize that format in a query from Delphi. SQLA seems
to always require 'yyyy/mm/dd' since I always get the complaint that it
can't convert the parameter to a date/time format when I don't use this
format. I need to use the other format to access other databases (Oracle,
Sybase, Interbase). Is there an option I can set to get it to recognize
this date format without reformatting my dates for the queries?

 

Re:SQL Anywhere dates


I think there's a setting in SQL-A that determines the date format used, I
can't recall which SET variable it is, tho.

Quote
MailStop wrote in message <01bd8023$9a402e30$d4026b83@dell_286>...
>Even if I change the database date format in SQLA to 'mm/dd/yyyy', I can't
>seem to get it to recognize that format in a query from Delphi. SQLA seems
>to always require 'yyyy/mm/dd' since I always get the complaint that it
>can't convert the parameter to a date/time format when I don't use this
>format. I need to use the other format to access other databases (Oracle,
>Sybase, Interbase). Is there an option I can set to get it to recognize
>this date format without reformatting my dates for the queries?

Other Threads