Hi Friends
Thursday, July 5, 2012
To convert any date filed with time to date without time like 1-Jan-2012 00:00:00.00
update TableName set Datefield=cast(convert(varchar,datefield,106) as datetime)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment