General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL datetime --> VFP date in a query
Hallo all
I wonder if somebody have a solution on a dateproblem.
I want the datepart of a datetimefield from an SQL server.
Something like this:
select "datepart of a datetimefield" as "datefield" from MySQLtable
I hope you understand my question, I have looked everywhere for a simple solution on this.
Of course I can convert the datetimefield in VFP later, after the SQL query is done, but are there some way to do the convert direct in the query.
Thanks in advance
/Kjell
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