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