| Author |
 Topic  |
|
|
phrankbooth
Posting Yak Master
USA
151 Posts |
 Posted - 05/20/2013 : 14:34:15
|
This:
SELECT SUBSTRING(convert(varchar, getdate(), 126),0,10)
Gives me:
2013-05-2
But I need:
2013-05-02
I had thought the DD would have automatically done that.
--PhB |
|
|
MIK_2008
Aged Yak Warrior
Pakistan
991 Posts |
Posted - 05/20/2013 : 14:46:01
|
Are you looking for only date portion???
SELECT Convert(date,getdate())
P.S. I would suggest to handle formatting on the front end of the application (if you need it in any application). Else stick with the standard date type with in SQL.
Cheers
MIK |
 |
|
|
phrankbooth
Posting Yak Master
USA
151 Posts |
Posted - 05/20/2013 : 14:53:31
|
thanks for the quick reply!
There's no front end. These are internal calls.
--PhB |
|
|
|
jimf
Flowing Fount of Yak Knowledge
USA
2869 Posts |
Posted - 05/20/2013 : 14:59:26
|
Start your substring at 1, not 0, and always declare the lengths of your varchars!
SELECT SUBSTRING(convert(varchar(10), getdate(), 126),1,10)
Jim
Everyday I learn something that somebody else already knew |
|
|
|
Lamprey
Flowing Fount of Yak Knowledge
4148 Posts |
Posted - 05/20/2013 : 15:49:44
|
SELECT FORMAT(SYSDATETIME(), 'yyyy-MM-dd', 'en-us') |
|
|
|
bandi
Flowing Fount of Yak Knowledge
India
2124 Posts |
Posted - 05/21/2013 : 00:49:59
|
--see this format.....( 2013-05-02)
DECLARE @date DATE = getdate()-19
SELECT CONVERT(VARCHAR(10), @date, 120) AS [YYYY-MM-DD]
SELECT REPLACE(CONVERT(VARCHAR(10), @date, 111), '/', '-') AS [YYYY-MM-DD]
--
Chandu |
|
|
|
madhivanan
Premature Yak Congratulator
India
22626 Posts |
Posted - 05/22/2013 : 06:32:27
|
The FORMAT function is available from verrsion 2012 onwards. However if you use front end application to show this format, use format function there
Madhivanan
Failing to plan is Planning to fail |
|
|
| |
Topic |
|
How to get double digit day WITH YYYY-MM-DD??
