| Subject | RE: [firebird-support] Time format for insertion into table |
|---|---|
| Author | Clay Shannon |
| Post date | 2005-02-11T19:58:35Z |
OK, then it's DBWD that displays it that way.
I could probably change a setting to alter that (display format), but it's
not that big of a deal.
Clay Shannon,
Dimension 4 Software
-----Original Message-----
From: Ivan Prenosil [mailto:Ivan.Prenosil@...]
Sent: Friday, February 11, 2005 1:52 PM
To: Firebird-Support
Subject: Re: [firebird-support] Time format for insertion into table
it is your application that does the formatting.
Firebird sends the result to client either in binary time format
(which is integer), or (if asked e.g. by CAST) as string
(in which case the result will be '15:00:00.0000', never am/pm)
Ivan
Yahoo! Groups Links
I could probably change a setting to alter that (display format), but it's
not that big of a deal.
Clay Shannon,
Dimension 4 Software
-----Original Message-----
From: Ivan Prenosil [mailto:Ivan.Prenosil@...]
Sent: Friday, February 11, 2005 1:52 PM
To: Firebird-Support
Subject: Re: [firebird-support] Time format for insertion into table
> I must admit it seems rather odd to me that you insert the value asdisplay
> '15:00:00' and it is displayed from the DB as '3:00:00 PM'--why not
> it as it was entered?No, it is not displayed *from the DB* as '3:00:00 PM',
it is your application that does the formatting.
Firebird sends the result to client either in binary time format
(which is integer), or (if asked e.g. by CAST) as string
(in which case the result will be '15:00:00.0000', never am/pm)
Ivan
Yahoo! Groups Links