SQL Server 日期转换到字符串
0 |
Feb 22 2006 4:26PM |
CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) |
1 |
02/22/06 |
CONVERT(CHAR(8), CURRENT_TIMESTAMP, 1) |
2 |
06.02.22 |
CONVERT(CHAR(8), CURRENT_TIMESTAMP, 2) |
3 |
22/02/06 |
CONVERT(CHAR(8), CURRENT_TIMESTAMP, 3) |
4 |
22.02.06 |
CONVERT(CHAR(8), CURRENT_TIMESTAMP, 4) |
5 |
22-02-06 |
CONVERT(CHAR(8), CURRENT_TIMESTAMP, 5) |
6 |
22 Feb 06 |
CONVERT(CHAR(9), CURRENT_TIMESTAMP, 6) |
7 |
Feb 22, 06 |
CONVERT(CHAR(10), CURRENT_TIMESTAMP, 7) |
8 |
16:26:08 |
CONVERT(CHAR(8), CURRENT_TIMESTAMP, 8) |
9 |
Feb 22 2006 4:26:08:020PM |
CONVERT(CHAR(26), CURRENT_TIMESTAMP, 9) |
10 |
02-22-06 |
CONVERT(CHAR(8), CURRENT_TIMESTAMP, 10) |
11 |
06/02/22 |
CONVERT(CHAR(8), CURRENT_TIMESTAMP, 11) |
12 |
060222 |
CONVERT(CHAR(6), CURRENT_TIMESTAMP, 12) |
13 |
22 Feb 2006 16:26:08:020 |
CONVERT(CHAR(24), CURRENT_TIMESTAMP, 13) |
14 |
16:26:08:037 |
CONVERT(CHAR(12), CURRENT_TIMESTAMP, 14) |
20 |
2006-02-22 16:26:08 |
CONVERT(CHAR(19), CURRENT_TIMESTAMP, 20) |
21 |
2006-02-22 16:26:08.037 |
CONVERT(CHAR(23), CURRENT_TIMESTAMP, 21) |
22 |
02/22/06 4:26:08 PM |
CONVERT(CHAR(20), CURRENT_TIMESTAMP, 22) |
23 |
2006-02-22 |
CONVERT(CHAR(10), CURRENT_TIMESTAMP, 23) |
24 |
16:26:08 |
CONVERT(CHAR(8), CURRENT_TIMESTAMP, 24) |
25 |
2006-02-22 16:26:08.037 |
CONVERT(CHAR(23), CURRENT_TIMESTAMP, 25) |
100 |
Feb 22 2006 4:26PM |
CONVERT(CHAR(19), CURRENT_TIMESTAMP, 100) |
101 |
02/22/2006 |
CONVERT(CHAR(10), CURRENT_TIMESTAMP, 101) |
102 |
2006.02.22 |
CONVERT(CHAR(10), CURRENT_TIMESTAMP, 102) |
103 |
22/02/2006 |
CONVERT(CHAR(10), CURRENT_TIMESTAMP, 103) |
104 |
22.02.2006 |
CONVERT(CHAR(10), CURRENT_TIMESTAMP, 104) |
105 |
22-02-2006 |
CONVERT(CHAR(10), CURRENT_TIMESTAMP, 105) |
106 |
22 Feb 2006 |
CONVERT(CHAR(11), CURRENT_TIMESTAMP, 106) |
107 |
Feb 22, 2006 |
CONVERT(CHAR(12), CURRENT_TIMESTAMP, 107) |
108 |
16:26:08 |
CONVERT(CHAR(8), CURRENT_TIMESTAMP, 108) |
109 |
Feb 22 2006 4:26:08:067PM |
CONVERT(CHAR(26), CURRENT_TIMESTAMP, 109) |
110 |
02-22-2006 |
CONVERT(CHAR(10), CURRENT_TIMESTAMP, 110) |
111 |
2006/02/22 |
CONVERT(CHAR(10), CURRENT_TIMESTAMP, 111) |
112 |
20060222 |
CONVERT(CHAR(8), CURRENT_TIMESTAMP, 112) |
113 |
22 Feb 2006 16:26:08:067 |
CONVERT(CHAR(24), CURRENT_TIMESTAMP, 113) |
114 |
16:26:08:067 |
CONVERT(CHAR(12), CURRENT_TIMESTAMP, 114) |
120 |
2006-02-22 16:26:08 |
CONVERT(CHAR(19), CURRENT_TIMESTAMP, 120) |
121 |
2006-02-22 16:26:08.080 |
CONVERT(CHAR(23), CURRENT_TIMESTAMP, 121) |
126 |
2006-02-22T16:26:08.080 |
CONVERT(CHAR(23), CURRENT_TIMESTAMP, 126) |
127 |
2006-02-22T16:26:08.080 |
CONVERT(CHAR(23), CURRENT_TIMESTAMP, 127) |
130 |
24 ???? 1427 4:26:08:080PM |
CONVERT(CHAR(32), CURRENT_TIMESTAMP, 130) |
131 |
24/01/1427 4:26:08:080PM |
CONVERT(CHAR(25), CURRENT_TIMESTAMP, 131) |
最新文章
- 常见http status code
- Whole life
- string相关总结
- CentOS搭建svn服务器支持https访问
- 论文笔记之: Hierarchical Convolutional Features for Visual Tracking
- OOD沉思录 --- 类和对象的关系 --- 包含关系2
- Android intent-filter 简单用法
- drop,truncate与delete的区别
- 【原】Oracle查询指定表里的触发器
- HTML5数组方法
- 网易新闻首页iOS
- ThinkPHP运算符 与 SQL运算符 对比表
- 运维老鸟教你安装centos6.5如何选择安装包
- 人脸检测识别,人脸检测,人脸识别,离线检测,C#源码
- PHP防CC攻击代码
- 获取.properties后缀的数据
- fedora 28/29 配置 C++ 环境
- 在react/redux中使用Immutable
- STL总结
- MQ(转)
热门文章
- Submit Text 快捷键总结
- C# 调用Excel 出现服务器出现意外情况. (异常来自 HRESULT:0x80010105 (RPC_E_SERVERFAULT)
- springMVC下集成active MQ发送邮件
- centos7安装http服务
- Nodejs基础中间件
- error: could not read CFBundleIdentifier from Info.plist (null)解决方法之一
- django之分页、cookie装饰器
- 在ubuntu 14.04上安装2.6的内核
- java的print,printf,println以及输入
- 一位程序员如何修炼成CTO