Yikes! Who designed that mess?I'm working with a sql server database where all the datetimes are stored as text
so 3:15:49 PM on July 6 2015 is stored as
'2015070615154900'
Yikes! Who designed that mess?
That is not the default behavior for SQL. SQL has DateTime fields, just like Access.