把
'yyyy/MM/dd HH:mm:ss'
改为
'yyyy/MM/dd HH:mi:ss'
'yyyy/MM/dd HH:mm:ss'
改为
'yyyy/MM/dd HH:mi:ss'
解决方案 »
- 日期格式无法识别
- 请教一个Oracle的绑定变量的问题!急急急!
- 将ORACLE数据库设为只读?
- 调用包内自定义Record数组问题
- Processes到底能调多大
- 为什么v$logmnr_contents的session_info列client_info项是空的?
- 如何在oracle企业管理器中插入数据
- 初学者,请教一个简单问题!
- 大家好,我的oracle8.17装完用system/manager进来出现ora-01031:insufficient privileges该什么办
- 触发器 Create Tabel Or User
- 一个新手的困惑
- oracle for solarisx86 客户端下载
pdat=to_date('2004/11/26 08:04:44','YYYY/MM/DD HH24:MI:SS') where ORNO='COM00000008'
to_date的格式:
CC Century
SCC Century BC prefixed with -YYYY Year 2001
SYYY Year BC prefixed with -
IYYY ISO Year 2001
YY Year 01
RR Year 01 rollover for Y2K compatibility *
YEAR Year spelled out
SYEAR Year spelled out BC prefixed with -
BC BC/AD Indicator *Q Quarter : Jan-Mar=1, Apr-Jun=2MM Month of year 01, 02...12
RM Roman Month I, II...XII *
MONTH In full [January ]...[December ]
FMMONTH In full [January]...[December]
MON JAN, FEBWW Week of year 1-52
W Week of month 1-5
IW ISO std week of yearDDD Day of year 1-366 *
DD Day of month 1-31
D Day of week 1-7
DAY In full [Monday ]...[Sunday ]
FMDAY In full [Monday]...[Sunday]
DY MON...SUN
DDTH Ordinal Day 7TH
DDSPTH Spell out ordinal SEVENTH
J Julian Day (days since 31/12/4713)HH Hours of day (1-12)
HH12 Hours of day (1-12)
HH24 Hours of day (1-24)
SPHH Spell out SEVEN
AM am or pm *
PM am or pm *
A.M. a.m. or p.m. *
P.M. a.m. or p.m. *MI Minutes 0-59
SS Seconds 0-59 *
SSSS Seconds past midnight (0-86399) *