ravikaliappan

Forum Replies Created

Viewing 8 posts - 1 through 8 (of 8 total)

RE: How to convert varbinary to date

Thom A - Wednesday, August 9, 2017 7:03 AM
Just had a stab in the dark and tested all the following:
SELECT CONVERT(varbinary(MAX),CONVERT(datetime2(0), '20170809...

August 9, 2017 at 7:12 am

#1954621
RE: How to convert varbinary to date

Thom A - Wednesday, August 9, 2017 6:44 AM
how was the varbinary value created? Are you sure that the original value was...

August 9, 2017 at 6:48 am

#1954615
RE: How to convert varbinary to date

Luis Cazares - Wednesday, August 9, 2017 6:42 AM
ravikaliappan - Wednesday, August 9, 2017 5:31 AM

August 9, 2017 at 6:47 am

#1954614
RE: How to convert varbinary to date

ravikaliappan - Wednesday, August 9, 2017 6:39 AM
Thom A - Wednesday, August 9, 2017 6:33 AM

August 9, 2017 at 6:40 am

#1954604
RE: How to convert varbinary to date

Thom A - Wednesday, August 9, 2017 6:33 AM
Where did that value come from initially? How was the varbinary created? Is...

August 9, 2017 at 6:39 am

#1954603
RE: Converting Hour and Minute to Decimal

ravikaliappan - Wednesday, August 9, 2017 3:45 AM
ravikaliappan - Wednesday, August 9, 2017 3:37 AM

August 9, 2017 at 3:47 am

#1954568
RE: Converting Hour and Minute to Decimal

ravikaliappan - Wednesday, August 9, 2017 3:37 AM
Eirikur Eiriksson - Saturday, August 2, 2014 12:38 PM

August 9, 2017 at 3:45 am

#1954567
RE: Converting Hour and Minute to Decimal

Eirikur Eiriksson - Saturday, August 2, 2014 12:38 PM
Jeff Moden (8/2/2014)
Sean Lange (7/31/2014)
Sql server stores datetime as decimal. You can easily cast...

August 9, 2017 at 3:37 am

#1954566

Viewing 8 posts - 1 through 8 (of 8 total)