Subject Re: [firebird-support] Date Format
Author Dimitry Sibiryakov
On 1 Apr 2004 at 6:45, Mahesh Ishwar wrote:

> While inserting timestamp(or may be date) in a table, the format
>I've to stuck to is 'mm/dd/yyyy hh:mm:ss' (or 'mm/dd/yyyy' in case
>of date field). Is there any other way I can change the format while
>inserting timestamp in a table? Has local regional settings
>something to do with this format?

No. If you provide FB with date-as-string you are stuck to list of
recognised formats. Short list of recognized data formats:

mm/dd/yyyy
dd.mm.yyyy
yyyy-mm-dd
dd-MMM-yyyy, where MMM is an english short name of month.

> I'd a stored procedure just inserting timestamp data in a table. I
>passed the data in above mentioned format.

I just wonder why you pass data in string format. Doesn't your tool
allow you to pass data in binary form?

> It was working fine on few machines but on a particular machine the
>stored procedure was not working. It just hung. Just with a hit, I

I could understand if the procedure produced wrong result, but
hung... It must not be the case.

>Just wanted to confirm with this behaviour.

I can confirm that Firebird does not respect OS locale settings.

SY, Dimitry Sibiryakov.