Information générale
Titre:
Using CTOD() over Visual Foxpro ODBC Driver
Consider the following select statement sent from ASP (via the Visual Foxpro ODBC driver) on a table containing a field that stores date values as a string:
strQuery = "SELECT build, CTOD(build) buildasdate FROM project"
SET objRecordSet = objConn.Execute(strQuery)
A sample result set is as follows
build buildasdate
01/01/1998 01/01/1998
01/02/2000 01/02/2000
17/05/2000 NULL
Correct me if I'm wrong but the obvious explanation of the NULL value appearing is that CTOD is interpreting the date string as mm/dd/yy.
Is it possible for CTOD to interpret date strings dd/mm/yy?
I would also be interested to know how CTOD works over ODBC.
Thanks in advance
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement