General information
Category:
Database DAO/RDO/ODBC/ADO
Hi!
If you have a connection to an Access Database then the format() function will work, but if it is to a Sql Server Database then you have to use the convert() function from t-sql, for example:
select idtable, convert(nvarchar(10), shipdate, 111) as shipped from tableX
In this query string the 111 inside the convert function represents the format you want to give to the date: 111 is yyyy/mm/dd format, for all the other formats take a look at the Sql Server Books OnLine.
Arnaldo Colon.
Previous
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