Home > Backend Development > PHP Tutorial > php如何查询Oracle的DATE字段的时分秒?

php如何查询Oracle的DATE字段的时分秒?

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Release: 2016-06-20 12:27:18
Original
1472 people have browsed it

Oracle版本是11.2.0.1,PHP版本5.5.12
尝试了这种PHP查询方式:
DATE字段的字段名是XSSJ

$st = OCIParse($dbconn,"SELECT to_char(syslog.XSSJ,'YYYY-MM-DD HH24:MI:SS') FROM $MH_XW");
Copy after login

这样查询出来的数据显示的是“27-5月-2016”

想要输出“2016-05-27 19:42:00”这样的,求大神指导正确的写法,谢谢了!~~


回复讨论(解决方案)

请查阅 Oracle 手册!

$st = OCIParse($dbconn,"SELECT to_char(XSSJ,'YYYY-MM-DD HH:MI:SS') as XSSJ FROM $MH_XW");
Copy after login

后面加了as解决了,希望能帮忙同样遇到这问题的朋友

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template