ORACLE: TO_TIMESTAMP FUNCTION
来源:互联网 发布:淘宝网民族风女装刺绣 编辑:程序博客网 时间:2024/05/29 15:58
Oracle/PLSQL: To_Timestamp Function
In Oracle/PLSQL, the to_timestamp function converts a string to a timestamp.
The syntax for the to_timestamp function is:
to_timestamp( string1, [ format_mask ] [ 'nlsparam' ] )
string1 is the string that will be converted to a timestamp.
format_mask is optional. This is the format that will be used to convert string1 to a timestamp.
The following is a list of options for the format_mask parameter. These parameters can be used in many combinations.
Parameter Explanation YYYY 4-digit year MM Month (01-12; JAN = 01). MON Abbreviated name of month. MONTH Name of month, padded with blanks to length of 9 characters. DD Day of month (1-31). HH Hour of day (1-12). HH12 Hour of day (1-12). HH24 Hour of day (0-23). MI Minute (0-59). SS Second (0-59).
Applies To:
- Oracle 9i, Oracle 10g, Oracle 11g
For example:
to_timestamp('2003/12/13 10:13:18', 'YYYY/MM/DD HH:MI:SS')
would return '13-DEC-03 10.13.18.000000000 AM' as a timestamp value.
to_timestamp('2003/DEC/13 10:13:18', 'YYYY/MON/DD HH:MI:SS')
would also return '13-DEC-03 10.13.18.000000000 AM' as a timestamp value.
- ORACLE: TO_TIMESTAMP FUNCTION
- oracle to_timestamp
- oracle to_timestamp
- to_timestamp、to_timestamp、to_date 函数
- Oracle function
- oracle Function
- Oracle Function
- oracle function
- oracle function
- ORACLE function
- oracle function
- oracle function
- oracle function
- oracle function
- oracle---function
- oracle function
- [Oracle Function]使用常用的Oracle Function
- TO_TIMESTAMP数据库SQL时间转换
- 在XP下oracle端口穿防火墙问题
- 国家版权局:微软技术垄断会适得其反
- 使用KSES安全过滤输入数据
- jsp include 乱码问题的解决(自http://rainbow686.javaeye.com/blog/123363)
- 零开始Hibernate旅程(一个例子)
- ORACLE: TO_TIMESTAMP FUNCTION
- gridview实现文件的上传
- php 开发 ‘’和null的判断
- JSP实现文件下载代码
- hibernate开发主键生成方式(重要)
- 江民杀毒软件发展史(以发布版本为时间轴)
- JSP实现图片上传代码
- SQL SEVER 2000 安装中挂起问题
- 数据库连接实例