반응형
postgresql
SELECT to_char(now(), 'YYYY/MM/DD-HH24:MI:SS:MS'::text);
결과
"2016/08/11-18:48:06:547"
SELECT to_char(now(), 'YYYY/MM/DD-HH24:MI:SS:US'::text);
결과
"2016/08/11-18:48:24:492000"
| Pattern | Description |
| YYYY | year (4 or more digits) |
| YYY | last 3 digits of year |
| YY | last 2 digits of year |
| Y | last digit of year |
| MM | month number (01-12) |
| DDD | day of year (001-366) |
| DD | day of month (01-31) |
| D | day of the week, Sunday (1) to Saturday (7) |
| HH | hour of day (01-12) |
| HH12 | hour of day (01-12) |
| HH24 | hour of day (00-23) |
| MI | minute (00-59) |
| SS | second (00-59) |
| MS | millisecond (000-999) |
| US | microsecond (000000-999999) |
반응형
