to get only date or hour from getdate()

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

Either use datpart to get the pieces you need or look at CONVERT in BOL, for example

CONVERT(VARCHAR,GETDATE(),101) returns mm/dd/yyy

CONVERT(VARCHAR,GETDATE(),108) returns hh:mm:ss

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

rachel SSCommitted Points: 1626 More actions · Answer 2

What about if I want to take a date and turn it into this format: mmddyy

no slashes, hyphens etc.

Thanks!!

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 3

use datepart and concatenate.

datepart() + datepart() + datepart()

Steve Jones

Andy Jones, DBA Hall of Fame Points: 3641 More actions · Answer 4

Or

select replace(convert(varchar(8),getdate(),1),'/','')

You are limited using convert to the pre-defined list (see BOL), but removing the '/' gives you the format you require.

Regards,

Andy Jones

.

rachel SSCommitted Points: 1626 More actions · Answer 5

Thanks to both of you! I was hoping there was a format string command - but your suggestions will take care of it.

shrinivaskundarapu SSC Veteran Points: 272 More actions · Answer 6

Hi

select Replace(Convert(varchar(11),Getdate(),110),'-','')

Shrinivas L.K.