Subject | Re: [firebird-support] Date Format |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2004-04-01T07:43:02Z |
On 1 Apr 2004 at 6:45, Mahesh Ishwar wrote:
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.
allow you to pass data in binary form?
hung... It must not be the case.
SY, Dimitry Sibiryakov.
> While inserting timestamp(or may be date) in a table, the formatNo. If you provide FB with date-as-string you are stuck to list of
>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?
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. II just wonder why you pass data in string format. Doesn't your tool
>passed the data in above mentioned format.
allow you to pass data in binary form?
> It was working fine on few machines but on a particular machine theI could understand if the procedure produced wrong result, but
>stored procedure was not working. It just hung. Just with a hit, I
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.