cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
xiang
‎01-17-2016
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: time8 is automatically converted to datetime2 in sql server

by Calcite | Level 5 in SAS Programming
‎01-11-2016 12:18 AM
‎01-11-2016 12:18 AM
Hi PG   Thanks for your reply. Do you know why the first case happened? is it because of some sort of default option?   Thanks Xiang ... View more

time8 is automatically converted to datetime2 in sql server

by Calcite | Level 5 in SAS Programming
‎01-10-2016 11:00 PM
‎01-10-2016 11:00 PM
sas 9.2, sql server 2008 r2,odbc=sql server native client 10.0 data destlib.tab;    --sql server database set sourcelib.tab;  --local sas dataset run one column in sourcelib.tab is time8 type with values such as 17:37:33. after running the script above, the column in the sql server database has type datetime2(0) and the value becomes 1960-01-01 17:37:33.   another system sas 9.4, sql server 2012, odbc=sql server native client 11.0 same script the column in the sql server database becomes time(7) with the value 17:37:33.0000000   Could someone please tell me why the first scenario happens and where the control is? Thanks ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎01-17-2016 06:39 PM
Quick links