开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜