{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 相关推荐>> 的问题《How to get datetime in 24hour format from oracle d》','https://www.manongdao.com/q-1318166.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
Is there any other way to get datetime field from oracle database in 24hour format???like -> "select getxsddate(col_name) from tab_name" will get you datetime format as "2012-04-04T12:31:00"...I wanted to know if there are any other ways as i`m not satisfied with this format.
相关问题
- System.Data.OracleClient not working with 64 bit O
- Using a subquery within PLSQL conditional logic; e
- Oracle: pivot (coalesce) some counts onto a single
- Oracle TNS Permission Denied *
- Oracle: How to detect client process termination l
相关文章
- How to store an array of bytes in Oracle?
- Invoking a function call in a string in an Oracle
- Change Oracle SQL Query Text before submission [cl
- ORACLE Constraint to allow Null Value, IF
- Does Oracle's “date'[yyyy-mm-dd]'” lit
- SQL - Multiple Values comma separated when using G
- Getting Error Message For oci_execute() Error (PHP
- What are the ways to insert & retrieve BLOB data f
Another very simple way is to set, in the database nls parameters, the parameter date_format='DD-MM-YYYY HH24:MI:SS'
You can read more about
to_charfunction here