TOYYYYMMDD

Description

The

TOYYYYMMDD

function is used to convert different types of time expressions into a date format, specifically

YYYYMMDD

. This function accepts parameters of type

date

timestamp

and returns an integer type result.

Syntax

Parameters

```
expr
```
expr
: A time expression of type
```
date
```
date
or
```
timestamp
```
timestamp
.

Return Result

Returns an integer representing the input time expression in

YYYYMMDD

format.

Example

Using the current timestamp:
SELECT TOYYYYMMDD(now());

Assuming the current timestamp is

2022-01-01 15:00:00

, the return result is

20220101

Using a date in string format:
SELECT TOYYYYMMDD('2023-04-15') as res; +----------+ | res | +----------+ | 20230415 | +----------+
Using Timestamps to Convert to Dates:
SELECT TOYYYYMMDD(TIMESTAMP "2024-05-25 03:21:00") as res; +----------+ | res | +----------+ | 20240525 | +----------+
Use the current timestamp and format it as a date:
SELECT TOYYYYMMDD(CURRENT_TIMESTAMP() - INTERVAL '1 day') as res ; +----------+ | res | +----------+ | 20250120 | +----------+

Notes

When the input time expression cannot be converted to a date, the function will return
```
NULL
```
NULL
.
Please ensure that the input time expression is in the correct format, otherwise it may lead to incorrect results.

Summary

The

TOYYYYMMDD

function provides a convenient way to convert different types of time expressions into date format. By using this function, users can easily obtain the integer representation of a date, making it convenient for date calculations and comparisons.