Skip to content

Instantly share code, notes, and snippets.

@linuxbender
Created May 3, 2011 10:04
Show Gist options
  • Save linuxbender/953102 to your computer and use it in GitHub Desktop.
Save linuxbender/953102 to your computer and use it in GitHub Desktop.
MS SQL 2k8 Datetime convert - not working - just past to the inet
DECLARE @myDouble float(30)
SET @myDouble = 40666.4704123611
DECLARE @myLong bigint
SET @myLong = 634400182498630741
-- o.k double to DateTime
select @myDouble as NR , convert(datetime, @myDouble) as DT
-- select @myLong as NR , convert(datetime, @myLong,) as DT
select * from tblevent as e
where e.tblEventExportDate = convert(datetime,'04.26.2011 15:58:58')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment