using convert function filter time or date only from datetime column Written by Suresh Sharma on May 06, 2008 in Sql Server with 1 comment SELECT convert(char(11), getdate(),109)May 6 2008SELECT convert(char(8), getdate(),108)12:51:32and so on u can change according input different char length and style value Share: Email ThisBlogThis!Share to XShare to Facebook
i want to change year in date field in sql 2005
ReplyDelete