A weblog about programming in Python, C#, Java, Perl and C++ - and the occasional comment on PyCS development
new: discuss community servers on the CommunityServerWiki!
also available in XML
Copyright (c) 2002 Phillip Pearson
Apparently it's OK to say 'yyyy.MM.dd' in SQL, but I get an "
It seems that inserting dates into MS SQL Server can be a fairly code-consuming process if you want to do it in Italian. Is there a standard way to do this sort of thing? Will always using the US format work?
MySQL seems to support the semi-standard yyyy-MM-dd format. Does Access?
I'm writing code here in New Zealand that I don't want to blow up when someone somewhere else runs it. Where is the official, 'safe' way to do it?!
(If anyone can find me the MS Jet version of this page, please drop me a line!)
For the moment I'm querying like this:
It's not pretty, but it works.
Comment on this post [ so far]