Mark Forums Read

pcb out file datetime format

Go Back

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Reply

Page 1 of 17

1

#1

Old

Harolds

Posts: n/a

pcb out file datetime format - 08-29-2008 , 05:41 PM

If I were to read the bcp out file, and I had the 8 bytes of the datetime
field in the file, how would I convert those 8 bytes into a datetime?
--
Harolds

Reply With Quote

#2

Old

Erland Sommarskog

Posts: n/a

Re: pcb out file datetime format - 08-30-2008 , 04:59 AM

Harolds (harolds (AT) nospam (DOT) nospam) writes:

Quote:

If I were to read the bcp out file, and I had the 8 bytes of the datetime
field in the file, how would I convert those 8 bytes into a datetime?

The first four bytes are the number of days since 1900-01-01, the second
four bytes are the number of ticks since midnight. A tick in this context
is 3.333 milliseconds.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote

#3

Old

Erland Sommarskog

Posts: n/a

Re: pcb out file datetime format - 08-30-2008 , 04:59 AM

Harolds (harolds (AT) nospam (DOT) nospam) writes:

Quote:

If I were to read the bcp out file, and I had the 8 bytes of the datetime
field in the file, how would I convert those 8 bytes into a datetime?

The first four bytes are the number of days since 1900-01-01, the second
four bytes are the number of ticks since midnight. A tick in this context
is 3.333 milliseconds.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote

#4

Old

Erland Sommarskog

Posts: n/a

Re: pcb out file datetime format - 08-30-2008 , 04:59 AM

Harolds (harolds (AT) nospam (DOT) nospam) writes:

Quote:

If I were to read the bcp out file, and I had the 8 bytes of the datetime
field in the file, how would I convert those 8 bytes into a datetime?

The first four bytes are the number of days since 1900-01-01, the second
four bytes are the number of ticks since midnight. A tick in this context
is 3.333 milliseconds.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote

#5

Old

Erland Sommarskog

Posts: n/a

Re: pcb out file datetime format - 08-30-2008 , 04:59 AM

Harolds (harolds (AT) nospam (DOT) nospam) writes:

Quote:

If I were to read the bcp out file, and I had the 8 bytes of the datetime
field in the file, how would I convert those 8 bytes into a datetime?

The first four bytes are the number of days since 1900-01-01, the second
four bytes are the number of ticks since midnight. A tick in this context
is 3.333 milliseconds.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote

#6

Old

Erland Sommarskog

Posts: n/a

Re: pcb out file datetime format - 08-30-2008 , 04:59 AM

Harolds (harolds (AT) nospam (DOT) nospam) writes:

Quote:

If I were to read the bcp out file, and I had the 8 bytes of the datetime
field in the file, how would I convert those 8 bytes into a datetime?

The first four bytes are the number of days since 1900-01-01, the second
four bytes are the number of ticks since midnight. A tick in this context
is 3.333 milliseconds.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote

#7

Old

Erland Sommarskog

Posts: n/a

Re: pcb out file datetime format - 08-30-2008 , 04:59 AM

Harolds (harolds (AT) nospam (DOT) nospam) writes:

Quote:

If I were to read the bcp out file, and I had the 8 bytes of the datetime
field in the file, how would I convert those 8 bytes into a datetime?

The first four bytes are the number of days since 1900-01-01, the second
four bytes are the number of ticks since midnight. A tick in this context
is 3.333 milliseconds.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote

#8

Old

Erland Sommarskog

Posts: n/a

Re: pcb out file datetime format - 08-30-2008 , 04:59 AM

Harolds (harolds (AT) nospam (DOT) nospam) writes:

Quote:

If I were to read the bcp out file, and I had the 8 bytes of the datetime
field in the file, how would I convert those 8 bytes into a datetime?

The first four bytes are the number of days since 1900-01-01, the second
four bytes are the number of ticks since midnight. A tick in this context
is 3.333 milliseconds.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote

#9

Old

Erland Sommarskog

Posts: n/a

Re: pcb out file datetime format - 08-30-2008 , 04:59 AM

Harolds (harolds (AT) nospam (DOT) nospam) writes:

Quote:

If I were to read the bcp out file, and I had the 8 bytes of the datetime
field in the file, how would I convert those 8 bytes into a datetime?

The first four bytes are the number of days since 1900-01-01, the second
four bytes are the number of ticks since midnight. A tick in this context
is 3.333 milliseconds.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote

#10

Old

Erland Sommarskog

Posts: n/a

Re: pcb out file datetime format - 08-30-2008 , 04:59 AM

Harolds (harolds (AT) nospam (DOT) nospam) writes:

Quote:

If I were to read the bcp out file, and I had the 8 bytes of the datetime
field in the file, how would I convert those 8 bytes into a datetime?

The first four bytes are the number of days since 1900-01-01, the second
four bytes are the number of ticks since midnight. A tick in this context
is 3.333 milliseconds.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote

Reply

Page 1 of 17

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.