JWorld@TW the best professional Java site in Taiwan
      註冊 | 登入 | 全文檢索 | 排行榜  

» JWorld@TW » Servlet/JSP 討論區  

按列印兼容模式列印這個話題 列印話題    把這個話題寄給朋友 寄給朋友   
reply to postflat modego to previous topicgo to next topic
作者 Get date from Oracle DB

發文: 28
積分: 0
於 2005-11-15 00:41 user profilesend a private message to userreply to postreply to postsearch all posts byselect and copy to clipboard. 
ie only, sorry for netscape users:-)add this post to my favorite list
While I am trying to get the value from a date feild in the oracle DB using JSTL running on a ora92 server, I found that I can only get the DATE part, rather than the time part. Eg, the completed value is 01-Dec-1969 12:12:23 AM and I can only get "01-Dec-1969 "

<sql:query sql="SELECT PA_CREATED_DT FROM APPRAISALS WHERE PA_ID =${paID}" var="rsDt" dataSource="${ds}"/>
<c:forEach items="${rsDt.rows}" var="rowDt">
<c:out value="${rowDt.PA_CREATED_DT}"/>

While testing this code on the Tomcat, I can get the completed value. Dose this mean that Oracle server has special date formation? How would I be able to get the completed date while running on the oracle server?
Thanks in advance

reply to postreply to post
人氣 標題 作者 字數 發文時間
1433 Get date from Oracle DB brolinuk 718 2005-11-15 00:41
» JWorld@TW »  Servlet/JSP 討論區

reply to postflat modego to previous topicgo to next topic
Jump to the top of page

JWorld@TW 本站商標資訊

Powered by Powerful JuteForum® Version Jute 1.5.8