"함수 today()"의 두 판 사이의 차이

1번째 줄: 1번째 줄:
[[category: date]]
;today
;today
;curdate
;curdate
4번째 줄: 5번째 줄:


==Bash==
==Bash==
[[category: Bash]]
<source lang='bash'>
<source lang='bash'>
TODAY=`date +%Y-%m-%d`
TODAY=`date +%Y-%m-%d`
13번째 줄: 15번째 줄:
</source>
</source>


==cmd==
==CMD==
[[category: CMD]]
<source lang='bash'>
<source lang='bash'>
set today=%date%
set today=%date%
28번째 줄: 31번째 줄:


==C#==
==C#==
[[category: Csharp]]
<source lang='csharp'>
<source lang='csharp'>
String today = DateTime.Now.ToString("yyyy-MM-dd");
String today = DateTime.Now.ToString("yyyy-MM-dd");
33번째 줄: 37번째 줄:


==Java==
==Java==
[[category: Java]]
<source lang='java'>
<source lang='java'>
Date date = new Date();
Date date = new Date();
43번째 줄: 48번째 줄:


==PHP==
==PHP==
[[category: PHP]]
<source lang='php'>
<source lang='php'>
$today = date('Y-m-d');
$today = date('Y-m-d');
64번째 줄: 70번째 줄:


==SQL==
==SQL==
[[category: SQL]]
===MySQL===
===MySQL===
[[category: MySQL]]
<source lang='sql'>
<source lang='sql'>
SELECT CURDATE();
SELECT CURDATE();
70번째 줄: 78번째 줄:


===Oracle===
===Oracle===
[[category: Oracle]]
<source lang='sql'>
<source lang='sql'>
SELECT to_char(sysdate, 'YYYY-MM-DD') FROM dual;
SELECT to_char(sysdate, 'YYYY-MM-DD') FROM dual;
86번째 줄: 95번째 줄:
==참고 자료==
==참고 자료==
*http://eqcode.com/wiki/Today
*http://eqcode.com/wiki/Today
[[category: date]]
[[category: Bash]]
[[category: cmd]]
[[category: Csharp]]
[[category: Java]]
[[category: PHP]]
[[category: MySQL]]
[[category: Oracle]]

2014년 6월 3일 (화) 22:16 판

today
curdate
  • example: "1903-12-28"

1 Bash

TODAY=`date +%Y-%m-%d`
echo $TODAY
TODAY=$(date +%Y-%m-%d)
echo $TODAY

2 CMD

set today=%date%
echo %today%
set today=%date:~0,10%
echo %today%
for /f "tokens=1-3 delims=- " %a in ('echo %date%') do set today=%a-%b-%c
echo %today%

3 C#

String today = DateTime.Now.ToString("yyyy-MM-dd");

4 Java

Date date = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String today = sdf.format(date);
String today = new SimpleDateFormat("yyyy-MM-dd").format(new Date());

5 PHP

$today = date('Y-m-d');

6 Ruby

today = Time.now.strftime "%Y-%m-%d"
puts today
today = Time.new.strftime "%Y-%m-%d"
puts today
require 'date'
today = Date.today
puts today

7 SQL

7.1 MySQL

SELECT CURDATE();

7.2 Oracle

SELECT to_char(sysdate, 'YYYY-MM-DD') FROM dual;

7.3 PostgreSQL

SELECT current_date;

8 같이 보기

9 참고 자료

문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}