CONVERT(datetime,CONVERT(varchar(10),GETDATE(),101))
Example in use
Convert (char(10),bc.sxbc_next_billto_dttm,101) AS sxbc_next_billto_dttm,
Subscribe to:
Post Comments (Atom)
A blog to keep all the trivial pursuit type knowledge I've learned about computers in one place
About Me
No comments:
Post a Comment