开发者

How do I convert an Access 2007 DateTime to mysql datetime format?

开发者 https://www.devze.com 2023-02-12 15:53 出处:网络
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 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:

开发者_如何学Go
select 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;
0

精彩评论

暂无评论...
验证码 换一张
取 消