I have a database (Access 2007) and want to represent a datetime field as a Mysql datetime format. For example, "23.02.2011 12:23:01" as "2011.02.23 12:23:01".
I'm using SQL to Access from C# (OLE DB connection).
What stored functions of Access can I use?
Example:
开发者_如何学Goselect FUNCTION_NAME(DateTimeField, "yyyy.MM.dd HH:mm:ss") from tableName;
What's the FUNCTION_NAME I need?
How about Format?
select Format(DateTimeField, "yyyy.MM.dd HH:mm:ss") from tableName;
精彩评论