SQL Server DateTime

(imported topic written by SystemAdmin)

We building an interface into the Bigfix database using the database API. Is there an easy way to convert the Bigfix time into a SQL Server datetime format, or do I have to parse the whole statement and convert it manually?

(imported comment written by SystemAdmin)

Bigfix date/time = Sat, 14 Nov 2009 11:29:39 -0500

SQL Server datetime needed = 11/14/2000 11:29

(imported comment written by NoahSalzman)

This is one way to do it:

Q: (year of it as string & “/” & month of it as two digits & “/” & day_of_month of it as string) of current date & " " & first 5 of (current time_of_day as string)

A: 2009/11/16 10:26

(imported comment written by BenKus)

And if you are doing this in SQL, I think you need to parse it manually (we use standard MIME date format, but I don’t know if SQL has a converter for that).