LoginSignup
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 1 year has passed since last update.

@hongjitufang25(ひろき @就職活動中 )

SQL 日付と時刻の演算

Posted at

日付と時刻の関数や演算子

  • 現在の日付 ・・・ current_date

  • 現在の時刻 ・・・ current_timestamp

  • n日後の日付 ・・・ d + n

  • n日前の日付 ・・・ d - n

  • x時間後の時刻 ・・・ interval'x hour'

  • x時間前の時刻 ・・・ - interval'x hour'

  • extrfact ・・・ 日付や時刻の特定の部分(年や月) までを取り出す。

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?