I just had a request from our Oracle team to see if I could supply them with dates in a MMDDYYYYHHMMSS format. Came here and found what I need in all of about 30 seconds. Thanks.

Select the particular year,month, day,pls do following query

 ---------------------------------------------------------------------------------------

select * from barrowBooks where year(barrow_date)='2008' and month(barrow_date)='11' and day(barrow_date)='12'  order by barrow_date desc

convert the date and time  using this query

----------------------------------------------------------------

select convert(char(11),getdate(),108) -->Result of time  11:18:18

select convert(char(10),getdate(),101) -->Result of Date  11/06/2008

Actually, I was simply complimenting the "tip" as it provided exactly what I needed for ANY date:

 select replace(convert(varchar, getdate(),101),'/','') + replace(convert(varchar, getdate(),108),':','')

This converts any MSSQL datetime to MMDDYYYYHHMMSS - exactly what the Oracle folks wanted!

Thanks anyway :-)

It's very helpful info thanks for help!!!!!

I would like to see the complete date and time a DD-MM-YYYY HH:MM:SS

I use: convert(varchar,getdate(),105) + convert(varchar,getdate(),108)

I get: 16-05-201213:42:18

How would I get the extra space between the Date and Time to get 16-05-2012 13:42:18

Tessa,

Would this work for you?

convert(varchar,getdate(),105) + ' ' + convert(varchar,getdate(),108)

Is there any reason you would not use this format:

Have you also seen these tips:

http://www.mssqltips.com/sqlservertip/2588/new-date-and-time-functions-in-sql-server-2012/

http://www.mssqltips.com/sqlservertip/1616/sql-server-2008-date-and-time-data-types/

HTH.

Thank you,
Jeremy Kadlec

its very very helpful...

still i need few more details... for few more formulaes....

i want extracting date from sql server,using php how to get this?? i used

$d=convert(varchar,getdate(),101);

echo $d;

 this is not working

Don't forget 23:   2006-12-30

How to convert datetime format stored data to 24hr time format in SSMS 2008?
Any idea on this?

Dev,

Can you post the date format you are seeing in SSMS and the final format you would like?

Thank you,
Jeremy Kadlec

hI

BELOW MY REQUORMENT

Input - 20121130121020 = output 2012/11/30 12:10:20

Can any one help me out this

satheeshkumar,

Have you checked out Tim Ford's tip - http://www.mssqltips.com/sqlservertip/1712/sql-server-function-to-convert-integer-date-to-datetime-format/?

I believe he has a function to take care of the date logic, but I think you will have to modify it to include the time logic you need.

HTH.

Thank you,
Jeremy Kadlec