함수 DAYOFYEAR()

1 개요

함수 DAYOFYEAR()

2 Bash

date +%j --date 2015-02-22
# 053

date +%j --date 2017-06-15
# 166

3 JavaScript

var d = new Date('2015-02-22');
var day_of_year = Math.floor( (d - new Date(d.getFullYear(), 0, 0)) / 86400000 );
console.log( day_of_year );
// 53

function day_of_year(str) {
  var d = new Date(str);
  return Math.floor( (d - new Date(d.getFullYear(), 0, 0)) / 86400000 );
}
console.log( day_of_year('2017-06-15') );
// 166

4 SQL

4.1 MySQL

SELECT DAYOFYEAR('2015-02-22');
-- 53

SELECT DAYOFYEAR("2017-06-15");
-- 166

5 같이 보기

• 함수 DAYOFMONTH()
• 함수 DAYOFWEEK()
• 서수날짜