Manejo de fechas oracle-sql server

| | | |
| | | |
| | | |
| | | |
Formato Fechas | | |
select convert(varchar,getdate(),101) from... |
| | | |
| | | |
| | | |
| | | |
| | | || | | |
| | | |
| | | |
| | | |
| | | |
0 or 100 | | | |
mon dd yyyy hh:miAM (or PM) | |
| | | |
| | | |
| | | |
| | | |
101 | | | |mm/dd/yy | | | |
| | | |
| | | |
| | | |
| | | |
102 | | | |
yy.mm.dd | | | |
| | | |
| | | |
| | | |
| | | |
103 | | | |
dd/mm/yy| | | |
| | | |
| | | |
| | | |
| | | |
104 | | | |
dd.mm.yy | | | |
| | | |
| | | |
| | | |
| | | |
105 | | | |
dd-mm-yy | | | || | | |
| | | |
| | | |
| | | |
106 | | | |
dd mon yy | | | |
| | | |
| | | |
| | | |
| | | |
107 | | | |
Mon dd, yy | | | |
|| | |
| | | |
| | | |
| | | |
108 | | | |
hh:mm:ss | | | |
| | | |
| | | |
| | | |
| | | |
9 or 109 | | | |
mon dd yyyy hh:mi:ss:mmmAM (orPM) |
| | | |
| | | |
| | | |
| | | |
110 | | | |
mm-dd-yy | | | |
| | | |
| | | |
| | | |
| | | |
111 | | | |
yy/mm/dd | | | |
|| | |
| | | |
| | | |
| | | |
112 | | | |
yy/mm/dd | | | |
| | | |
| | | |
| | | |
| | | |
13 or 113 | | | |
dd mon yyyyhh:mm:ss:mmm(24h) | |
| | | |
| | | |
| | | |
| | | |
114 | | | |
hh:mi:ss:mmm(24h) | | |
| | | |
| | | |
| | | |
| | | |
20 or 120 | | | |
yyyy-mm-ddhh:mi:ss(24h) | |
| | | |
| | | |
| | | |
| | | |
21 or 121 | | | |
yyyy-mm-dd hh:mi:ss.mmm(24h) | |
| | | |
| | | |
| | | |
| | | |
126 |...