About This Document
The Gnumeric Manual, version 1.8
- Welcome!
- How to Use this Manual
- A Quick Introduction
- Gnumeric Elements
- Working with Data
- Advanced Analysis
- Graphics: Plots, Images, Widgets, and Drawings
- Configuring Gnumeric
- Working with Files
- Printing
- Getting More Help
- Reporting a Problem
- Extending Gnumeric
- Function Reference
  - Bitwise Operations
  - Complex
  - Database
  - Date/Time
    
    DATE
    
    DATE2UNIX
    
    DATEDIF
    
    DATEVALUE
    
    DAY
    
    DAYS360
    
    EDATE
    
    EOMONTH
    
    HOUR
    
    ISOWEEKNUM
    
    ISOYEAR
    
    MINUTE
    
    MONTH
    
    NETWORKDAYS
    
    NOW
    
    SECOND
    
    TIME
    
    TIMEVALUE
    
    TODAY
    
    UNIX2DATE
    
    WEEKDAY
    
    WEEKNUM
    
    WORKDAY
    
    YEAR
    
    YEARFRAC
  - Engineering
  - Erlang
  - Finance
  - Gnumeric
  - Information
  - Logic
  - Lookup
  - Mathematics
  - Number Theory
  - Random Numbers
  - Statistics
  - String
- Keybinding Reference

UNIX2DATE

The Gnumeric Manual, version 1.8
Function Reference
Date/Time

UNIX2DATE —

Synopsis
Description
Examples
See also

Synopsis

UNIX2DATE(unixtime)

Description

UNIX2DATE converts a unix time into a spreadsheet date and time.

A unix time is the number of seconds since midnight January 1, 1970.

Examples

See also

NOW, DATE, DATE2UNIX.