Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Converting SQL Server timestamp field to datetime
Message
From
04/01/2006 08:42:35
Sergey Berezniker
New York, United States
 
 
To
04/01/2006 08:39:16
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Converting SQL Server timestamp field to datetime
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01083089
Message ID:
01083091
Views:
16
You cannot because SQL Server timestamp field value has nothing to do with a date and time. The correct (ANSI standard) data type name is 'rowversion'.

>I have a SQL table with a timestamp field, and I need to convert that to DATETIME in my VFP application. Any advice?
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform