I’ve always found it difficult to wrap my head around the various language date implementations because each one has its idiosyncrasies. Each time I have to work with a new language, I have to re-learn their date handling constructs, which is a bit of a pain. Databases are the worst culprits in this respect because each database offers a date, datetime or timestamp field and each database engine has its own expectation for how that date time field should be queried. SQL Server and C# work together to simplify matters a bit (or so I thought). Consider the following sample:
1 2 3 4 5 6 7 8 9 10 11
Today I learned, by delegating the task to a friend, that Python exposes the MySQL datetime in a much easier-to-grasp manner. A sample date interaction in python would be:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
All it takes is to enclose the date in quotes and invoke the
date_object.isoformat() method, and voila, you’re done. What can I say, I’m really starting to dig python.