Date and Time format in SQL Query 1

[MasterPO]

I am trying to insert records into an existing table that has a specific format for dates and times in the existing records:
Date format (Last_Chg_Dt) is '2005-09-16 00:00:00.0000'
Time format (Last_Chg_Time) is '1900-01-01 12:26:16.060'

Using GetDate(), I cannot find a format to replicate these. They return either a date or a time or both, but not in the format as shown above!

Any ideas?

 

[amrita418]

There should be an easier way to doing this but try this:

select convert(datetime, convert(varchar, getdate(), 101)), 
       convert(datetime, convert(varchar, getdate(), 114))

Regards,
AA

 

[MasterPO]

Thanks - I don't know how I missed these format numbers!

 

[RustyAfro]

Is there a good place to get the definition for the format numbers?

 

[amrita418]

You should be able to find it at Books Online (BOL).

Also googling on convert function sql server should take you to msdn link.

Regards,
AA

 

[SQLBill]

Look up CONVERT in the BOL.

-SQLBill

Posting advice: FAQ481-4875

 

[SQLBill]

BTW-there are a couple of FAQs on Dates and Times in this forum's FAQ area. Check them out.

-SQLBill

Posting advice: FAQ481-4875