SQL - Timestamp Data Type

> (Data|State) Management and Processing > (Data Type|Data Structure) > (Relation|Table) - Tabular data > Structured Query Language (SQL)

1 - About

Sql datatype

Advertising

3 - Representation

3.1 - Text

12:30:01 # only time in timestamps ?
yyyy-mm-dd hh:mm:ss.s

where:

  • yyyy is the 4 digit representation of year
  • mm is the 2 digit representation of month
  • dd is the 2 digit representation of day
  • hh is the 2 digit representation of hour in 24-hour clock notation
  • mm is the 2 digit representation of minute
  • ss.s is the 3 digit representation of second with a precision of at least 1/10 of a second