General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hey Bill,
What I'm going with is just bringing over the date/time value over from SQL Server, then using a flag in several of my classes that handle dates to handle the date/time to date issue. My users just don't want to see the time portion of the date/time value.
Doug
>>Is there a way via SQL-pass-thru to return a table from SQL Server with datetime fields as dates?
>>
>>Would creating a datatype on SQL Server to limit the portion of the datetime field to just display the date be an option?
>>
>>Thanks
>>Doug
>
>Hi Doug,
>As Arne said, with SPT, it is a 2-step process to get a VFP date datatype. However, with Remote Views, you can define the datatype. Just another option. I use a combination of SPT and RV in my applications.
>HTH,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only