SQL Server Script Generator CAST datetime values from hex

Question

I need to generate insert script from SQL Server and when i am using SQL Server Script Generator it CAST datetime values from hex e.g.

CAST(xxxxxxxxxxxxx as dateTime)

How can i avoid this ? I want actual value in script

You can't disable that unfortunately; possible duplicate of Problems with Data Script Generation — Alex K.
– Alex K., Commented Apr 18, 2013 at 11:35

Anvesh · Accepted Answer · 2013-04-18 12:27:01Z

4

Unfortunatly this is not possible , SQL Server internally produce hex value as DateTime value.

This hex value is logically divided into two group one is Date & other is Time.

e.g. 0x00009CEF00A25634 - hex value.

Date part :- 0x00009CEF (decimal 40175)

Time part :- 00A25634 (decimal 10638900)

If you select this hex value like,

select CAST (0x00009CEF00A25634 as datetime)

it return, 2009-12-30 09:51:03.000

I hope this answer is helpful for you.

Thanks.

answered Apr 18, 2013 at 12:27

Anvesh

7,8073 gold badges48 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

InTheWorldOfCodingApplications Over a year ago

So does that mean if i leave i as it is, it will insert the correct date into target table?

Anvesh Over a year ago

Yes, If you see that generated insert script then there is already CAST function . SQL Server just show hex value but it has already put hex value into CAST function so now you can use generated script for insertion which will insert real DateTime value. Let me know for further query . Thanks...!

Collectives™ on Stack Overflow

SQL Server Script Generator CAST datetime values from hex

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related