# Julianday Function in SQLite

SQLite Julianday Function
To convert a date as a Julian Day the SQLite Julianday function is used. The resultant is thus a floating-point number. A Julian Day can be simply understood as the number of days since November 24, 4714 BC 12:00 pm Greenwich time in the Gregorian calendar.

Syntax:

```julianday(timestring [, modifier1, modifier2, ... modifier_n ] )
```

Example 1:

`SELECT julianday('now');`

Output:

`2458700.5`

Explanation:
In the above example, we are retrieving the current date.

Example 2:

`SELECT julianday('now', 'start of month');`

Output:

`2458696.5`

Explanation:
In the above example, we are retrieving the first day of the month.

Example 3:

`SELECT julianday('2019-08-05', 'start of month');`

Output:

`2458696.5`

Explanation:
In the above example, we are retrieving the first day of the month.

Example 4:

`SELECT julianday('now', 'start of month','+1 month', '-1 day');`

Output:

`2458726.5`

Explanation:
In the above example, we are retrieving the last day of the month.

Example 5:

`SELECT julianday('2019-08-05', 'start of month','+1 month', '-1 day');`

Output:

`2458726.5`

Explanation:
In the above example, we are retrieving the last day of the month.

Example 6:

`SELECT julianday('now','+2 years');`

Output:

`2459431.5`

Explanation:
In the above example, we are adding 2 years to the current date.

Example 7:

`SELECT julianday('2019-08-05','+2 years');`

Output:

`2459431.5`

Explanation:
In the above example, we are adding 2 years to the specified date.

Example 8:

`SELECT julianday('now','+2 days');`

Output:

`2458702.5`

Explanation:
In the above example, we are adding 2 days to the current date.

Example 9:

`SELECT julianday('2019-08-05','+2 days');`

Output:
2458702.5

Explanation:
In the above example, we are adding 2 days to the specified date.

Example 10:

`SELECT julianday('2019-08-05','-2 days');`

Output:

`2458698.5`

Explanation:
In the above example, we are subtracting 2 days from the specified date.