| Subject | Re: [firebird-support] Re: Problems selecting on Timestamp. |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2011-11-09T10:04:26Z |
On Wed, 09 Nov 2011 09:59:23 -0000, "tomsee7" <tomconlon7@...>
wrote:
sure if Firebird supports this US-locale conversion in all locales, and you
would also need to make sure that your application will behave in all
locales it will run in and supply a correctly formatted string.
Even better of course would be to simply use a parametrized query which
assigns a timestamp value (eg java.sql.Timestamp in JDBC), instead of using
string conversions.
wrote:
> Also, '30-Jun-2011 08:35:26' is explicit and unambiguous.Is it? Technically it is locale-dependent conversion as well. I am not
sure if Firebird supports this US-locale conversion in all locales, and you
would also need to make sure that your application will behave in all
locales it will run in and supply a correctly formatted string.
Even better of course would be to simply use a parametrized query which
assigns a timestamp value (eg java.sql.Timestamp in JDBC), instead of using
string conversions.