This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:29 pm, [email protected] wrote: Den 2011-11-09 10:39 skrev Mark Rotteveel såhär: > > On Wed, 9 Nov 2011 10:35:18 +0100, Kjell Rilbe <[email protected] > <mailto:kjell.rilbe%40datadia.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/YYYY while > >> 07.11.2011 is interpreted as DD/MM/YYYY? > >> > > Sorry, I don't know. I just wanted to point out that there are different > > > ways to interpret a date string and that you should make sure that your > > date string is actually interpreted the way you intend. How you choose > > to do this is up to you: try it out in your DB (recommended), read docs, > > > ask here, ... > > > > You could for example try this: > > > > select cast ('6.11.2011 08:35:26' as timestamp) from rdb$database > > select cast ('6.30.2011 08:35:26' as timestamp) from rdb$database > > select cast ('30.6.2011 08:35:26' as timestamp) from rdb$database > > Better just use timestamp '2011-06-30 08:35:26' or cast('2011-06-30 > 08:35:26' as timestamp), which should always work independent of the > locale > of the server. > And this is... *drumroll* ISO 8601! Yeehaaaw! :-) Kjell -- -------------------------------------- Kjell Rilbe DataDIA AB E-post: [email protected] Telefon: 08-761 06 55 Mobil: 0733-44 24 64 [Non-text portions of this message have been removed] ==Ticket History== On Mar 07, 2014 @ 03:29 pm, [email protected] wrote: No Comment. ------ On Mar 07, 2014 @ 03:29 pm, [email protected] 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/YYYY while > 07.11.2011 is interpreted as DD/MM/YYYY? > Sorry, I don't know. I just wanted to point out that there are different ways to interpret a date string and that you should make sure that your date string is actually interpreted the way you intend. How you choose to do this is up to you: try it out in your DB (recommended), read docs, ask here, ... You could for example try this: select cast ('6.11.2011 08:35:26' as timestamp) from rdb$database select cast ('6.30.2011 08:35:26' as timestamp) from rdb$database select cast ('30.6.2011 08:35:26' as timestamp) from rdb$database Kjell [Non-text portions of this message have been removed] ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links ------ On Mar 07, 2014 @ 03:29 pm, [email protected] wrote: 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 [email protected], 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] > ------ This is an automated response. Your issue has been noted. We'll be in touch soon. Please reply to this email or visit the URL below with any additional details. http://DANTOIN:9675/portal/view-help-request/234 [Non-text portions of this message have been removed]
