Valid styles for converting datetime to string

I wrote this little table and procedure to help me remember what style 104 did, or how to get HH:MM AM/PM out of a DATETIME column. Basically, it populates a table with the valid style numbers, then loops through those, and produces the result (and the syntax for producing that result) for each style, given… Continue reading Valid styles for converting datetime to string

Use CAST (or CONVERT) to handle Null Date values in Microsoft SQL Server

In an SQL Server View, a problem is that the DateTime field has many Null values which is causing a problem with the parsing of the data in MSAccess. How to I use CAST (or CONVERT) to handle Null Date values in my SQL Server view? There is a way to use CAST or CONVERT… Continue reading Use CAST (or CONVERT) to handle Null Date values in Microsoft SQL Server