Hello, everyone:
My table has a column that is DATETIME data type. The original format likes "1/21/2004". I want to check data lengh. However when I read the data by SELECT, SQL Server change the format to "Jan.-21-2004" automatically. Does any one has an idea to keep original datetime format? Thanks.
ZYTthere is no original format
you may use a format for input that sql server understands, but internally, the date is stored as an integer (number of days since the base date)
check out BOL (Books Online) for details
if you want to see a specific format when you SELECT a datatime value, then use the CONVERT function
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment