Subject | Re: [ib-support] FB, US vs UK date formats? |
---|---|
Author | Jason Frey |
Post date | 2002-07-12T23:45:24Z |
Thanks to all who responded.
I ended up writing a procedure to convert my string literal dates to the
common mm-ddd-yyyy (01-JAN-2002, for example). It seems to work on multiple
DB engines (FB and SQLServer is what I tested it on), and in multiple
different International settings in Windows. It was pretty easy to do, as
the queries that used it were created in a single file in my code. I didn't
go with parameters there because the list of parameters varies wildly (Can
go anywhere from one date, up to 30 or more).
- Jason
I ended up writing a procedure to convert my string literal dates to the
common mm-ddd-yyyy (01-JAN-2002, for example). It seems to work on multiple
DB engines (FB and SQLServer is what I tested it on), and in multiple
different International settings in Windows. It was pretty easy to do, as
the queries that used it were created in a single file in my code. I didn't
go with parameters there because the list of parameters varies wildly (Can
go anywhere from one date, up to 30 or more).
- Jason