Blogs about: Date Conversion
Featured Blog
Oracle 1/1/1700 date causes error in SSIS load to SQL Server 2008
When loading DATE type data from an Oracle database into a datetime column in a SQL Server database using SSIS an error such as this can occur: [OLE DB Destination [638]] Error: There was an error w… more →
Will Thrash's Blog
Oracle 1/1/1700 date causes error in SSIS load to SQL Server 2008
— 1 comment
willthrash wrote 7 months ago: When loading DATE type data from an Oracle database into a datetime column in a SQL Server database … more →
Error loading null dates from a text file into a database using SSIS.
willthrash wrote 8 months ago: I was creating an SSIS package to load data from a flat text file into a SQL Server 2008 database ta … more →
The Zunes Freezes: Update!
— 2 comments
Steven Pigeon wrote 11 months ago: The faulty code was leaked some time last week, and I’ve looked at it, and, well, it’s s … more →
The Zune Freezes: A Stupid, Avoidable Bug.
— 8 comments
Steven Pigeon wrote 11 months ago: The few Zune users where alienated today when they discovered that their Zunes just froze during boo … more →
Date Conversion to MySQL From Access/ SQL server
tbrander wrote 1 year ago: It took me a while to figure out how to convert dates from the format produced by Microsoft Access o … more →
Leap year, last day of the month the easy way?
maclochlainn wrote 1 year ago: You could write an ugly SQL statement full of CASE statements to derive the leap year moving forward … more →
Leap year not welcome by the TO_YMINTERVAL function
maclochlainn wrote 1 year ago: Playing around with illustrating date math, I noticed that Oracle 11g still hasn’t fixed the TO_YMIN … more →
Date Format Conversion
Nirav Patel wrote 1 year ago: The whole world is divided into different time zones and cultures. Every country has own style to di … more →
