Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
All I need is a simple date (bg)
Message
 
To
11/06/2001 11:43:12
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00516464
Message ID:
00517839
Views:
23
Hilmar,

The original post posed the question "Is there a way via SQL-pass-thru to return a table from SQL Server with datetime fields as dates?" My concern here was to pull a date/time value from SQL Server into a VFP cursor as a date data type, so that I would not have to mess around with rewriting code/class(es) to handle the date/time value.

(Also, since no MS folks have jumped in here to correct our understanding of mapping a SQL Server date/time column to a VFP date column, I believe that it's safe to say that we are at the end of this thread ... a sad ending at that :( )

>I may be misunderstanding something. However, just in case, I want to clarify the following:
>
>dtoc() converts a date value to a character - which, if I understand correctly, is NOT what you ant.
>
>ttod(), on the other hand, converts a datetime value to a date.
>
>Hilmar.
Previous
Reply
Map
View

Click here to load this message in the networking platform