Viewing post 1 (of 1 total)
you could use DATE_FORMAT() to deal with this issue
SELECT T.field
FROM
OPENQUERY(LINKSERVER, 'SELECT DATE_FORMAT(t.field,''%X-%m-%d %H:%i:%f'') as field...
April 2, 2013 at 3:23 am
#1602715