date format needed: 06/15/2017 12:00:00 AM

Question

date format needed: 06/15/2017 12:00:00 AM

polkadot

SSChampion

Points: 13664
More actions
June 15, 2017 at 1:25 pm

#338188

how to get it more directly than this?
SELECT CONVERT(VARCHAR(25), getdate(), 101) + ' 12:00:00 AM'
i need 12:00:00 AM in all rows.
--Quote me

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

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

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

polkadot - Thursday, June 15, 2017 1:25 PM
how to get it more directly than this?
SELECT CONVERT(VARCHAR(25), getdate(), 101) + ' 12:00:00 AM'
i need 12:00:00 AM in all rows.

That's the easiest way to do it in T-SQL. For a more direct (and preferred) way, just do it in the front end.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Joe Torre SSChampion Points: 10248 More actions · Answer 2

Joe Torre

SSChampion

Points: 10248

June 15, 2017 at 1:59 pm

#1947022


SELECT Cast(MyDatetime, as date) FROM MyTable;

Eirikur Eiriksson SSC Guru Points: 182916 More actions · Answer 3

Piling on
😎

This returns a DATETIME with time set at midnight:
SELECT CONVERT(DATETIME,CONVERT(DATE,GETDATE()),0)

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

Here's a post by Lynn with some common date routines. http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

It's a good one to bookmark if you work with dates frequently.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Vishal Vamja SSC Rookie Points: 47 More actions · Answer 5

hi,

I think this is what you want.. please check this will work for you.

SELECT CONVERT(VARCHAR(50),GETDATE(),101) + ' ' +right(convert(varchar(20),GETDATE(),100),7)