Converting datetime to shortdatetime
Posted on 2007-04-03
I am trying to convert a date field so I can yes it in a query
Original data is CrDate with data type of datetime. 2007-04-02 23:00:15.397
I would like to convert it to smalldatetime so I can run queries against it i.e. WHERE (CrDate = '4/2/2007')
I see a function CONVERT ( data_type [ ( length ) ] , expression [ , style ] ), but I'm not sure what to substitute such as style.
Environment SQL Server 2000
I would appreciate any suggstions. Thanks. DC900