Introduction
Quick Start
Table Design
Data Loading
Data Export
Using StarRocks
Reference
- SQL Reference
  - User Account Management
    - ALTER USER
    - CREATE ROLE
    - CREATE USER
    - DROP ROLE
    - DROP USER
    - GRANT
    - REVOKE
    - SET PASSWORD
    - SET PROPERTY
    - SHOW GRANTS
  - Cluster Management
  - DDL
  - DML
  - Data Types
    - Numeric
      - BIGINT
      - LARGEINT
      - SMALLINT
      - TINYINT
      - BOOLEAN
      - DECIMAL
      - DOUBLE
      - FLOAT
      - INT
    - String
      - CHAR
      - VARCHAR
      - STRING
    - Date
      - DATE
      - DATETIME
    - Others
      - HLL
      - BITMAP
      - JSON
  - Auxiliary Commands
    - DESCRIBE
- Function Reference
  - Date Functions
    - convert_tz
    - curdate
    - current_timestamp
    - curtime
    - datediff
    - date_add
    - date_format
    - date_sub
    - date_trunc
    - day
    - dayname
    - dayofmonth
    - dayofweek
    - dayofyear
    - from_days
    - from_unixtime
    - hour
    - minute
    - month
    - monthname
    - now
    - second
    - str_to_date
    - timediff
    - timestampadd
    - timestampdiff
    - to_date
    - to_days
    - unix_timestamp
    - utc_timestamp
    - weekofyear
    - year
  - Geographic Functions
  - String Functions
    - append_trailing_char_if_absent
    - ascii
    - char_length
    - concat
    - concat_ws
    - ends_with
    - find_in_set
    - get_json_double
    - get_json_int
    - get_json_string
    - group_concat
    - instr
    - lcase
    - left
    - length
    - locate
    - lower
    - lpad
    - ltrim
    - money_format
    - null_or_empty
    - regexp_extract
    - regexp_replace
    - repeat
    - reverse
    - right
    - rpad
    - split
    - split_part
    - starts_with
    - strleft
    - strright
  - JSON Functions
    - Overview of JSON functions and operators
    - JSON constructor functions
    - JSON query and processing functions
    - JSON operators
  - Aggregate Functions
    - any_value
    - approx_count_distinct
    - avg
    - bitmap
    - count
    - hll_union_agg
    - max
    - min
    - percentile_approx
    - retention
    - stddev
    - stddev_samp
    - sum
    - variance
    - square
    - var_samp
  - Bitmap Functions
  - Array Functions
  - cast function
  - hash function
  - Cryptographic Functions
    - md5
    - sha2
  - Math Functions
    - RAND
    - square
- System Variables
- Error Code
- System Limit
Administration
- Build in Docker
- Manage a cluster
- Configuration
- Scale In and Out
- Backup and Restore
- Data Recovery
  - Data Recovery
  - Restore FEs
- Replica
- Query Planning
- Profiling
- Monitor and Alert
- User Privilege
- Authentication
- Resource Management
FAQ
- Deploy
- Data Migration
  - Data Ingestion
  - Data Export
- SQL
- Other FAQs
Benchmark
- SSB Benchmark
- TPC-H Benchmark
Release Notes
- v2.2
- v2.1
- v2.0
- v1.19

from_unixtime

description

Syntax

DATETIME FROM_UNIXTIME(INT unix_timestamp[, VARCHAR string_format])

onvert the unix timestamp to the corresponding time format. The format returned should be specified by string_format.

The default format is yyyy-MM-dd HH:mm:ss. It also supports the formats in date_format.

It inputs integers and returns strings.

Currently, string_format supports the following formats:

%Y：Year  e.g.：2014，1900
%m：Month   e.g.：12，09
%d：Day  e.g.：11，01
%H：Hour  e.g.：23，01，12
%i：Minute  e.g.：05，11
%s：Second  e.g.：59，01

Other formats in string_format are invalid and be returned as NULL.

If the specified timstamp is less than 0 or more than 253402271999, it will be returned as NULL. The range for timestamp is: 1970-01-01 00:00:00 ~ 9999-12-31 23:59:59.

example

MySQL > select from_unixtime(1196440219);
+---------------------------+
| from_unixtime(1196440219) |
+---------------------------+
| 2007-12-01 00:30:19       |
+---------------------------+

MySQL > select from_unixtime(1196440219, 'yyyy-MM-dd HH:mm:ss');
+--------------------------------------------------+
| from_unixtime(1196440219, 'yyyy-MM-dd HH:mm:ss') |
+--------------------------------------------------+
| 2007-12-01 00:30:19                              |
+--------------------------------------------------+

MySQL > select from_unixtime(1196440219, '%Y-%m-%d');
+-----------------------------------------+
| from_unixtime(1196440219, '%Y-%m-%d')   |
+-----------------------------------------+
| 2007-12-01                              |
+-----------------------------------------+

MySQL > select from_unixtime(1196440219, '%Y-%m-%d %H:%i:%s');
+--------------------------------------------------+
| from_unixtime(1196440219, '%Y-%m-%d %H:%i:%s')   |
+--------------------------------------------------+
| 2007-12-01 00:30:19                              |
+--------------------------------------------------+

keyword

FROM_UNIXTIME,FROM,UNIXTIME

In this article

from_unixtime