> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# RESET {session variable}
export const InternalLink = ({version, path = "", children, ...props}) => {
let detectedVersion = version || "stable";
if (typeof window !== 'undefined' && !version) {
const match = window.location.pathname.match(/\/docs\/([^/]+)/);
if (match) {
detectedVersion = match[1];
}
}
const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
return
{children}
;
};
The `RESET` statement resets a session variable to its default value for the client session.
## Required privileges
No privileges are required to reset a session setting.
## Synopsis
## Parameters
| Parameter | Description |
| -------------- | -------------------------------------------------------------------------------------------------- |
| `session\_var` | The name of the session variable. |
## Example
You can use `SET.. TO DEFAULT` to reset a session variable as well.
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SET extra_float_digits = -10;
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW extra_float_digits;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
extra_float_digits
--------------------
-10
(1 row)
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT random();
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
random
---------
0.20286
(1 row)
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> RESET extra_float_digits;
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SHOW extra_float_digits;
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
extra_float_digits
--------------------
0
(1 row)
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
> SELECT random();
```
```text theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
random
-------------------
0.561354028296755
(1 row)
```
## Known Limitations
* `SET` and `RESET` do not properly apply `ROLLBACK` within a transaction. For example:
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
SET TIME ZONE +2;
BEGIN;
SET TIME ZONE +3;
ROLLBACK;
SHOW TIME ZONE;
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
timezone
------------
<+03>-03
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
SET TIME ZONE +2;
BEGIN;
RESET TIME ZONE;
ROLLBACK;
SHOW TIME ZONE;
```
```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
timezone
------------
UTC
```
## See also
* `SET session variable`
* `SHOW session variable`
* `SHOW DEFAULT SESSION VARIABLES FOR ROLE`