Click here to Skip to main content
13,044,927 members (43,042 online)
Rate this:
Please Sign up or sign in to vote.
See more:
How do you create a DateTime in a specific format in SQL Server
Posted 11-Dec-11 8:36am
Updated 11-Dec-11 15:26pm
Rate this: bad
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.
Monjurul Habib 11-Dec-11 21:26pm
Rate this: bad
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

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 11 Dec 2011
Copyright © CodeProject, 1999-2017
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