Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: (untagged)
How do you create a DateTime in a specific format in SQL Server
Posted 11-Dec-11 9:36am
Edited 11-Dec-11 16:26pm
v3
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

A DateTime does not have a format: it is stored as a a number of microseconds since an arbitrary point in time.
You can use the SQL FORMAT function[^] to do it, but I don't recommend it - it is much better to return a DateTime value and then format it for display at the last moment. If you format it in SQL, then you are fixing the format to one which may not be what the user is used to: if he normally gets US format, then European is not helpful. If he expects European and gets Japanese, it is also a pain.
  Permalink  
Comments
Monjurul Habib at 11-Dec-11 21:26pm
   
5!
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

thank you
I want to store date only without time
in the form I am use the fromat date in the code but the store date and time
can you help
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 381
1 Sergey Alexandrovich Kryukov 265
2 Praneet Nadkar 237
3 Marcin Kozub 225
4 /\jmot 189
0 OriginalGriff 8,284
1 Sergey Alexandrovich Kryukov 7,407
2 DamithSL 5,614
3 Maciej Los 4,989
4 Manas Bhardwaj 4,986


Advertise | Privacy | Mobile
Web04 | 2.8.1411023.1 | Last Updated 11 Dec 2011
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100