함수 now()

Jmnote (토론 | 기여)님의 2014년 6월 3일 (화) 21:57 판 (→‎Ruby)
  • example: 2011-01-01 21:00:00

1 Bash

NOW=`date +%Y-%m-%d\ %H:%M:%S`

2 C#

String now = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss");

3 CMD

set now=%date% %time%
echo %now%
REM 2012-08-24 15:00:22.05

4 Java

Date date = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String now = sdf.format(date);
String now = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());

5 PHP

$now = date('Y-m-d H:i:s');

6 Ruby

now = Time.new
puts now
# 2000-03-14 01:59:00 +0000
now = Time.now.strftime "%Y-%m-%d %H:%M:%S"
puts now
# 2000-03-14 01:59:00

7 SQL

7.1 MySQL

select now();
select sysdate();

7.2 Oracle

select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') as "Now" from dual;

7.3 PostgreSQL

SELECT CURRENT_TIMESTAMP;
SELECT LOCALTIMESTAMP;

8 같이 보기