|
-
Nov 15th, 2009, 04:56 PM
#6
Re: MSSQL Customize Date & Time Format
What is sql statement to get date & time format as below in MSSQL?
Format like this ==> "dd/mm/yyyy hh:mm:ss PM"
Select Convert(varchar, GetDate(),103) + ' ' + LTrim(Substring(Convert(varchar, GetDate(),109),13,8) + ' ' + Right(Convert(varchar, GetDate(),109),2))
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote