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? --- 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] >