SQL Server DateTime

Customizations
1

(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?

2

(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

3

(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

4

(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).

Ben