[firebird-support] Firebird Conference 2011

2011-11-09 Thread Alexey Kovyazin
Hello All, The Firebird Project invites all Firebird users and developers to participate in the Firebird Conference 2011, which will take place in *Luxembourg, November 25-26, 2011*. The Firebird Conference 2011 will be devoted to a variety of important topics: Firebird SQL language

[firebird-support] Re: Problems selecting on Timestamp.

2011-11-09 Thread canacourse
Thanks Helen, 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. TIA --- In firebird-support@yahoogroups.com, Helen Borrie helebor@... wrote: At 07:45 AM 9/11/2011, canacourse wrote: How may I

Re: [firebird-support] Re: Problems selecting on Timestamp.

2011-11-09 Thread Kjell Rilbe
Den 2011-11-09 10:31 skrev canacourse såhär: 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/ while 07.11.2011 is interpreted as DD/MM/? Sorry, I don't know. I just wanted to point out that there are

Re: [firebird-support] Re: Problems selecting on Timestamp.

2011-11-09 Thread Mark Rotteveel
On Wed, 9 Nov 2011 10:35:18 +0100, Kjell Rilbe kjell.ri...@datadia.se wrote: Den 2011-11-09 10:31 skrev canacourse såhär: 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/ while 07.11.2011 is interpreted

[firebird-support] Re: Problems selecting on Timestamp.

2011-11-09 Thread tomsee7
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On Wed, 9 Nov 2011 10:35:18 +0100, Kjell Rilbe kjell.rilbe@... wrote: Den 2011-11-09 10:31 skrev canacourse såhär: Kjell, Doesn’t using the dot separator imply that non us date formats are being

Re: [firebird-support] Re: Problems selecting on Timestamp.

2011-11-09 Thread Mark Rotteveel
On Wed, 09 Nov 2011 09:59:23 -, tomsee7 tomconl...@gmail.com wrote: Also, '30-Jun-2011 08:35:26' is explicit and unambiguous. Is it? Technically it is locale-dependent conversion as well. I am not sure if Firebird supports this US-locale conversion in all locales, and you would also need to

Re: [firebird-support] Re: Problems selecting on Timestamp.

2011-11-09 Thread Mark Rotteveel
On Wed, 9 Nov 2011 11:21:23 +0100, Kjell Rilbe kjell.ri...@datadia.se wrote: And this is... *drumroll* ISO 8601! Yeehaaaw! :-) I know that, but you just mentioned ISO 8601 without giving an example: not everyone associates ISO 8601 directly with -MM-dd :) Mark

Re: [firebird-support] Re: Problems selecting on Timestamp.

2011-11-09 Thread Kjell Rilbe
Den 2011-11-09 11:25 skrev Mark Rotteveel såhär: On Wed, 9 Nov 2011 11:21:23 +0100, Kjell Rilbe kjell.ri...@datadia.se mailto:kjell.rilbe%40datadia.se wrote: And this is... *drumroll* ISO 8601! Yeehaaaw! :-) I know that, but you just mentioned ISO 8601 without giving an example: not

Re: [firebird-support] Re: Problems selecting on Timestamp.

2011-11-09 Thread Mark Rotteveel
On Wed, 09 Nov 2011 23:32:14 +1300, Helen Borrie hele...@iinet.net.au wrote: At 11:04 PM 9/11/2011, Mark Rotteveel wrote: On Wed, 09 Nov 2011 09:59:23 -, tomsee7 tomconl...@gmail.com wrote: Also, '30-Jun-2011 08:35:26' is explicit and unambiguous. Is it? Yes. As is '11/06/2011' - as