ADO : formatting date from DB
Posted on 2003-03-12
i have an ADO control and a MSHFlexgrid that displays data :
adodc1.recordsource = "select format(mydate) as date from mytable"
Since the format function is not given a second argument,
it uses the regional settings.
It works with Access, but on SQL Server, the format function does
not exist. How to replace it ?
Coding an user-defined function with same name ? how ?
I looked at the existing functions Cast and Convert, but they do not
allow to use regional settings.
I would like to avoid rewriting all the sql queries in my vb project ;)