> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.
## Submitting Feedback
If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:
POST https://docs.firebolt.io/feedback
```json
{
"path": "/reference-sql/functions-reference/date-and-time/to-yyyymmdd",
"feedback": "Description of the issue"
}
```
Only submit feedback when you have something specific and actionable to report.
> Reference material for the TO_YYYYMMDD function
# TO_YYYYMMDD
export const QueryWindow = ({content}) => {
const {sql, result} = content;
const [inited, setInited] = useState(false);
const buttonRef = useRef(null);
useEffect(() => {
if (!inited && buttonRef.current) {
runQuery(buttonRef.current, true);
setInited(true);
}
}, []);
return
Interactive SQL Playground 🔥
{sql}
The Firebolt playground server is currently unavailable. Using precomputed query results.
;
};
Extracts year, month and day from a `DATE`, `TIMESTAMP`, or `TIMESTAMPTZ` value and combines them into an integer beginning with the four-digit year followed by the two-digit month followed by the two-digit day.
`TO_YYYYMMDD()` is equivalent to `EXTRACT(YEAR FROM ) * 10000 + EXTRACT(MONTH FROM ) * 100 + EXTRACT(DAY FROM );`
## Syntax
```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
TO_YYYYMMDD()
```
## Parameters
| Parameter | Description | Supported input types |
| :------------- | :------------------------------------------------------ | :--------------------------------- |
| `` | The expression from which the time units are extracted. | `DATE`, `TIMESTAMP`, `TIMESTAMPTZ` |
`TIMESTAMPTZ` values are converted to local time according to the session's `time_zone` setting before extracting the time units.
## Return Types
`INT`
## Remarks
The `TO_YYYYMMDD` function can be used in the `PARTITION BY` clause of `CREATE TABLE` commands.
```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
CREATE TABLE test (
t TIMESTAMP
)
PARTITION BY TO_YYYYMMDD(t);
```
## Example