All Articles on SQL - Date And Time

Convert varchar uk date value to correct datetime value using 103 113 styles

Posted 23 March 2010 - Category SQL Sub Category Date And Time

This can prove annoying when the system assumes mm/dd/yyyy usa format as opposed to dd/mm/yyyy uk format.

UDF to work out a date value from a string version held in different formats

Posted 24 March 2010 - Category SQL Sub Category Date And Time

A string version of date can be entered differently which makes the translation to a proper date type difficult. This function will do this for you.

Choose from the right hand menu to see full lists within subcategories