Sybase数据库关于GetDate()所需编号对应的日期格式(测试结果如下)

sybae数据库和其他数据的编码对应格式还是有稍许区别, 在此记录一下,以备后用.

测试SQL语句:SELECT CONVERT(varchar(100), GETDATE(), 编号)

[17:09:46.442]  编号:0 ----- Dec  4 2015  5:10PM

[17:09:46.450]  编号:1 ----- 12/04/15
[17:09:46.456]  编号:2 ----- 15.12.04
[17:09:46.462]  编号:3 ----- 04/12/15
[17:09:46.474]  编号:4 ----- 04.12.15
[17:09:46.482]  编号:5 ----- 04-12-15
[17:09:46.492]  编号:6 ----- 04 Dec 15
[17:09:46.499]  编号:7 ----- Dec 04, 15
[17:09:46.504]  编号:8 ----- 17:10:03
[17:09:46.514]  编号:9 ----- Dec  4 2015  5:10:03:106PM
[17:09:46.521]  编号:10 ----- 12-04-15
[17:09:46.527]  编号:11 ----- 15/12/04
[17:09:46.533]  编号:12 ----- 151204
[17:09:46.540]  编号:13 ----- 15/04/12
[17:09:46.549]  编号:14 ----- 12/15/04
[17:09:46.556]  编号:15 ----- 04/15/12
[17:09:46.562]  编号:16 ----- Dec  4 2015 17:10:03
[17:09:46.569]  编号:17 -----  5:10PM
[17:09:46.580]  编号:18 ----- 17:10
[17:09:46.586]  编号:19 -----  5:10:03:180PM
[17:09:46.601]  编号:20 ----- 17:10:03:193
[17:09:46.614]  编号:21 ----- 15/12/04 17:10:03
[17:09:46.623]  编号:22 ----- 15/12/04  5:10PM
[17:09:46.632]  编号:23 ----- 2015-12-04T17:10:03
[17:09:46.684]  编号:24 ----- 服务器数据库执行SQL语句错误!
错误原因:24 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.717]  编号:25 ----- 服务器数据库执行SQL语句错误!
错误原因:25 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.725]  编号:26 ----- 服务器数据库执行SQL语句错误!
错误原因:26 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.734]  编号:27 ----- 服务器数据库执行SQL语句错误!
错误原因:27 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.748]  编号:28 ----- 服务器数据库执行SQL语句错误!
错误原因:28 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.757]  编号:29 ----- 服务器数据库执行SQL语句错误!
错误原因:29 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.765]  编号:30 ----- 服务器数据库执行SQL语句错误!
错误原因:30 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.774]  编号:31 ----- 服务器数据库执行SQL语句错误!
错误原因:31 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.788]  编号:32 ----- 服务器数据库执行SQL语句错误!
错误原因:32 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.800]  编号:33 ----- 服务器数据库执行SQL语句错误!
错误原因:33 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.809]  编号:34 ----- 服务器数据库执行SQL语句错误!
错误原因:34 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.819]  编号:35 ----- 服务器数据库执行SQL语句错误!
错误原因:35 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.827]  编号:36 ----- 服务器数据库执行SQL语句错误!
错误原因:36 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.833]  编号:37 ----- 服务器数据库执行SQL语句错误!
错误原因:37 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.840]  编号:38 ----- 服务器数据库执行SQL语句错误!
错误原因:38 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.846]  编号:39 ----- 服务器数据库执行SQL语句错误!
错误原因:39 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.856]  编号:40 ----- 服务器数据库执行SQL语句错误!
错误原因:40 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.864]  编号:41 ----- 服务器数据库执行SQL语句错误!
错误原因:41 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.870]  编号:42 ----- 服务器数据库执行SQL语句错误!
错误原因:42 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.879]  编号:43 ----- 服务器数据库执行SQL语句错误!
错误原因:43 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.894]  编号:44 ----- 服务器数据库执行SQL语句错误!
错误原因:44 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.904]  编号:45 ----- 服务器数据库执行SQL语句错误!
错误原因:45 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.911]  编号:46 ----- 服务器数据库执行SQL语句错误!
错误原因:46 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.919]  编号:47 ----- 服务器数据库执行SQL语句错误!
错误原因:47 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.926]  编号:48 ----- 服务器数据库执行SQL语句错误!
错误原因:48 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.934]  编号:49 ----- 服务器数据库执行SQL语句错误!
错误原因:49 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.947]  编号:50 ----- 服务器数据库执行SQL语句错误!
错误原因:50 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.960]  编号:51 ----- 服务器数据库执行SQL语句错误!
错误原因:51 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.972]  编号:52 ----- 服务器数据库执行SQL语句错误!
错误原因:52 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.980]  编号:53 ----- 服务器数据库执行SQL语句错误!
错误原因:53 is not a valid style number when converting from DATETIME to a character string.
[17:09:46.999]  编号:54 ----- 服务器数据库执行SQL语句错误!
错误原因:54 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.009]  编号:55 ----- 服务器数据库执行SQL语句错误!
错误原因:55 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.023]  编号:56 ----- 服务器数据库执行SQL语句错误!
错误原因:56 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.029]  编号:57 ----- 服务器数据库执行SQL语句错误!
错误原因:57 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.039]  编号:58 ----- 服务器数据库执行SQL语句错误!
错误原因:58 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.052]  编号:59 ----- 服务器数据库执行SQL语句错误!
错误原因:59 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.062]  编号:60 ----- 服务器数据库执行SQL语句错误!
错误原因:60 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.071]  编号:61 ----- 服务器数据库执行SQL语句错误!
错误原因:61 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.081]  编号:62 ----- 服务器数据库执行SQL语句错误!
错误原因:62 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.091]  编号:63 ----- 服务器数据库执行SQL语句错误!
错误原因:63 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.105]  编号:64 ----- 服务器数据库执行SQL语句错误!
错误原因:64 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.114]  编号:65 ----- 服务器数据库执行SQL语句错误!
错误原因:65 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.125]  编号:66 ----- 服务器数据库执行SQL语句错误!
错误原因:66 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.132]  编号:67 ----- 服务器数据库执行SQL语句错误!

错误原因:67 is not a valid style number when converting from DATETIME to a character string.

[17:09:47.139]  编号:68 ----- 服务器数据库执行SQL语句错误!

错误原因:68 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.147]  编号:69 ----- 服务器数据库执行SQL语句错误!
错误原因:69 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.155]  编号:70 ----- 服务器数据库执行SQL语句错误!
错误原因:70 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.163]  编号:71 ----- 服务器数据库执行SQL语句错误!
错误原因:71 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.171]  编号:72 ----- 服务器数据库执行SQL语句错误!
错误原因:72 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.179]  编号:73 ----- 服务器数据库执行SQL语句错误!
错误原因:73 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.187]  编号:74 ----- 服务器数据库执行SQL语句错误!
错误原因:74 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.200]  编号:75 ----- 服务器数据库执行SQL语句错误!
错误原因:75 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.209]  编号:76 ----- 服务器数据库执行SQL语句错误!
错误原因:76 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.216]  编号:77 ----- 服务器数据库执行SQL语句错误!
错误原因:77 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.225]  编号:78 ----- 服务器数据库执行SQL语句错误!
错误原因:78 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.231]  编号:79 ----- 服务器数据库执行SQL语句错误!
错误原因:79 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.239]  编号:80 ----- 服务器数据库执行SQL语句错误!
错误原因:80 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.245]  编号:81 ----- 服务器数据库执行SQL语句错误!
错误原因:81 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.253]  编号:82 ----- 服务器数据库执行SQL语句错误!
错误原因:82 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.260]  编号:83 ----- 服务器数据库执行SQL语句错误!
错误原因:83 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.267]  编号:84 ----- 服务器数据库执行SQL语句错误!
错误原因:84 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.274]  编号:85 ----- 服务器数据库执行SQL语句错误!
错误原因:85 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.281]  编号:86 ----- 服务器数据库执行SQL语句错误!
错误原因:86 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.300]  编号:87 ----- 服务器数据库执行SQL语句错误!
错误原因:87 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.308]  编号:88 ----- 服务器数据库执行SQL语句错误!
错误原因:88 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.316]  编号:89 ----- 服务器数据库执行SQL语句错误!
错误原因:89 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.322]  编号:90 ----- 服务器数据库执行SQL语句错误!
错误原因:90 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.329]  编号:91 ----- 服务器数据库执行SQL语句错误!

错误原因:91 is not a valid style number when converting from DATETIME to a character string.

[17:09:47.336]  编号:92 ----- 服务器数据库执行SQL语句错误!

错误原因:92 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.344]  编号:93 ----- 服务器数据库执行SQL语句错误!
错误原因:93 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.352]  编号:94 ----- 服务器数据库执行SQL语句错误!
错误原因:94 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.358]  编号:95 ----- 服务器数据库执行SQL语句错误!
错误原因:95 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.367]  编号:96 ----- 服务器数据库执行SQL语句错误!
错误原因:96 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.383]  编号:97 ----- 服务器数据库执行SQL语句错误!
错误原因:97 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.397]  编号:98 ----- 服务器数据库执行SQL语句错误!
错误原因:98 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.409]  编号:99 ----- 服务器数据库执行SQL语句错误!
错误原因:99 is not a valid style number when converting from DATETIME to a character string.
[17:09:47.414]  编号:100 ----- Dec  4 2015  5:10PM
[17:09:47.420]  编号:101 ----- 12/04/2015
[17:09:47.425]  编号:102 ----- 2015.12.04
[17:09:47.432]  编号:103 ----- 04/12/2015
[17:09:47.438]  编号:104 ----- 04.12.2015
[17:09:47.445]  编号:105 ----- 04-12-2015
[17:09:47.451]  编号:106 ----- 04 Dec 2015
[17:09:47.457]  编号:107 ----- Dec 04, 2015
[17:09:47.469]  编号:108 ----- 17:10:04
[17:09:47.475]  编号:109 ----- Dec  4 2015  5:10:04:070PM
[17:09:47.481]  编号:110 ----- 12-04-2015
[17:09:47.491]  编号:111 ----- 2015/12/04
[17:09:47.500]  编号:112 ----- 20151204
[17:09:47.512]  编号:113 ----- 2015/04/12
[17:09:47.517]  编号:114 ----- 12/2015/04
[17:09:47.524]  编号:115 ----- 04/2015/12
[17:09:47.530]  编号:116 ----- Dec  4 2015 17:10:04
[17:09:47.535]  编号:117 ----- 2015/12/04 17:10:04
[17:09:47.540]  编号:118 ----- 2015/12/04  5:10PM
[17:09:47.548]  编号:119 ----- 服务器数据库执行SQL语句错误!
错误原因:119 is not a valid style number when converting from DATETIME to a character string.