dongliugu8843
2012-02-20 11:00
浏览 230

PHP中的Oracle Epoch时间戳的Oracle时间戳

I've got an oracle Database with an TIMESTAMP (6) WITH LOCAL TIME ZONE column that returns me values like this:

20-FEB-12 11.41.17.799000 AM

How can i parse those into a normal unix timestamp in PHP?
strtotime() doesn't work (returns false)

图片转代码服务由CSDN问答提供 功能建议

我有一个带有 TIMESTAMP(6)WITH LOCAL TIME ZONE的oracle数据库 返回值的列如下:

20-FEB-12 11.41.17.799000 AM

我如何解析 那些在PHP中的正常unix时间戳?
strtotime()不起作用(返回false)

  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dongnius85154 2012-02-20 12:40
    已采纳

    I just found i can use TO_CHAR to turn the Timestamp into something more parseable within the database query.

    There is a description here: http://infolab.stanford.edu/~ullman/fcdb/oracle/or-time.html

    已采纳该答案
    打赏 评论

相关推荐 更多相似问题