请教各位:
这样地日期如何在oracle中如何转化,才能被oracle识别?十一月 9 2005 1:42PM谢谢!!
这样地日期如何在oracle中如何转化,才能被oracle识别?十一月 9 2005 1:42PM谢谢!!
解决方案 »
- AIX下如何配置Oracle
- 如何判断PL/SQL Developer 是否连上了数据库?
- 怎么不能赋值??????? 在线等!!!!!!!!!!
- 远程连接一个oracle数据库 监听该怎么配??
- 我创建了一个用户,但不能以normal方式登陆.
- 存储过程列表获取。
- date类型默认是减天数,能否减分钟?
- 简单的触发器问题,更新时另外一个表的相应字段也跟着更新!请各位帮忙,先行谢过
- 以下过程是什么错误?请指教
- sqlldr命令中,.dis文件与.bad文件有什么不同?被丢弃的记录和被拒绝的记录有什么不一样?不都是没入库的记录吗?
- oracle连接数的问题
- oracle中是否可以像SQL Server2000一样开发扩展存储过程调用外部DLL?
Format Model|Description
CC, SCC|Century (S prefixes BC dates with a minus sign)
YYYY, SYYYY|Year (S prefixes BC dates with a minus sign)
IYYY|Year based on ISO standard
YYY, YY, Y|Last three, two or one digits of the year
IYY, IY, I|Last three, two or one digits of the ISO year
Y,YYY|(Four Y's with comma) put a comma in the year (1,995)
YEAR, SYEAR|Year spelled out (S prefixes BC dates with a minus sign)
RR|Last two digits of year in another century (allows for year 2000)
BC, AD|BC or AD indicator
B.C., A.D.|BC or AD indicators with periods
Q|Numeric quarter of the year (1-4 with Jan-Mar=1)
MM|2 number month (Jan = 01)
RM|Roman numeral month
MONTH|Name of month spelled out (upper case - month is upper case)
MON|abbreviated name of month (upper case - month is upper case)
WW|Week of the year (1-53)
IW|Week of the year (1-52, 1-53) based on ISO standard
W|Week of month (1-5)
DDD|day of year (1-366) (Don't forget leap years)
DD|day of month (1-31)
DAY|Name of day (upper case, day is upper case)
DY|Abbreviated name of day
J|Julian day (Number of days since January 1, 4712 BC)
AM,PM|Meridian indicator
A.M., P.M.|Meridian indicator with periods.
HH, HH12|Hour of day (0-12)
HH24|Use 24 hour clock for hours (1-24)
MI|Minute (0-59)
SS|Second (0-60)
SSSSS|(five S's) seconds past midnight. (0-86399)
None|Date must be in the format 'DD-MON-YY';