471,079 Members | 946 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,079 software developers and data experts.

what's the correct syntax using DateFormat

Hi everyone,
Please help!
what's the correct syntax using DateFormat in SQL Server 2005.

Example. 05/04/07 00:00:00 i need this date show like this 05/04/07 i this regard the time.

Anyone who can help me this problems?
May 4 '07 #1
1 2874
hi try this

select convert(varchar,getdate(),1)
May 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Chris Cioffi | last post: by
7 posts views Thread by Jonathan Fine | last post: by
8 posts views Thread by Hermawih | last post: by
4 posts views Thread by Nitin Bhardwaj | last post: by
2 posts views Thread by Grant Merwitz | last post: by
3 posts views Thread by Geethu03 | last post: by
dzenanz
3 posts views Thread by dzenanz | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.