pulpfiction Posted January 20, 2006 Share Posted January 20, 2006 Hi Guys,The datatype of the field DOB in the sql server db is VARCHAR, I want to convert it to Date. Is this command correct.CONVERT(varchar, DOB, 103) TIA Link to comment Share on other sites More sharing options...
Kcarson Posted January 21, 2006 Share Posted January 21, 2006 Hi Guys,The datatype of the field DOB in the sql server db is VARCHAR, I want to convert it to Date. Is this command correct.CONVERT(varchar, DOB, 103) TIA<{POST_SNAPBACK}> Just about, you might need to write it varchar(10) or whatever. Here is a link to better describe it and the possible date formats.http://platinum.intersystems.com/csp/docbo...EY=RSQL_convert Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now