| Subject | Re: Problems selecting on Timestamp. |
|---|---|
| Author | canacourse |
| Post date | 2011-11-09T09:31:08Z |
Kjell,
Doesnât using the dot separator imply that non us date formats are being used? i.e. 07/11/2011 is interpreted as MM/DD/YYYY while 07.11.2011 is interpreted as DD/MM/YYYY?
Doesnât using the dot separator imply that non us date formats are being used? i.e. 07/11/2011 is interpreted as MM/DD/YYYY while 07.11.2011 is interpreted as DD/MM/YYYY?
--- In firebird-support@yahoogroups.com, Kjell Rilbe <kjell.rilbe@...> wrote:
>
> Den 2011-11-09 09:49 skrev canacourse s�h�r:
> >
> > I assume you meant cast ('6.11.2011 08:35:26' as timestamp);? I have
> > tried that but still no records are returned in Ibexpert or ISQL.
> >
> Make sure your string literal is interpreted the way you think. If only
> people would come to their senses and adopt the ISO 8601 standard. *sigh*
>
> For example, does '6.11.2011 08:35:26' result in Nov 6 or June 11?
>
> Kjell
>
>
> [Non-text portions of this message have been removed]
>