Discussion Locked
0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I want to save the date without the time format i.e. dd/mm/yyyy for e.g. instead of dd/mm/yyyy hh:mm:ss am/pm
5 replies
by mark_t
Are you talking about SQL Server datetime format, or just storing the date format as dd/mm/yyyy on a table ?
Why do you need to do this ? Is it not feasible to convert the date format into the required one when displayed ?
by reem
The question was auto-closed by TechRepublic
by jmiller1
A two digit year is the closest you can get without building your own date string:
SELECT CONVERT(char(12), GETDATE(), 1)
will return 08/16/02.
See 'CAST and CONVERT' in Books Online.
by reem
The question was auto-closed by TechRepublic
by reem
This question was auto closed due to inactivity
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
0 helpful
1 reply
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply
Discussion
Optimizing WordPress widgets and DOM size
0 helpful
3 replies