Question: I use a custom hook to support dark mode with tailwindcss in my new react-native app, created with Expo CLI. The TailwindProvider with the dark mode logic looks like this:

```js
const TailwindProvider: React.FC = ({ children }) => {
  const [currentColorScheme, setcurrentColorScheme] = useState(Appearance.getColorScheme());
  console.log("CurrentColorScheme:", currentColorScheme);
  const isDarkMode = currentColorScheme == "dark";
  const tw = (classes: string) => tailwind(handleThemeClasses(classes, isDarkMode))
  return <TailwindContext.Provider value={{ currentColorScheme, setcurrentColorScheme, tw, isDarkMode }}>{children}</TailwindContext.Provider>;
}

```

as you can see, i use the `Appearance.getColorScheme()` method from `react-native` to get the current ColorScheme. But both on iOS and Android, i always get `light` instead of `dark`, in debug as well as in production mode.

How can I fix this?

Answer: 
Use `systimestamp` since that includes a time zone.

```
select systimestamp at time zone 'US/Eastern'
  from dual;

```

should return a timestamp in the Eastern time zone (assuming your database time zone files are up to date).

Note that if you ask for a timestamp in EST, that should be an hour earlier than the current time in the Eastern time zone of the United States because the US is in Daylight Savings Time. So the Eastern time zone is in EDT currently not EST.
If you really want to use `SYSDATE` then you can use:

```sql
SELECT from_tz(CAST(sysdate AS TIMESTAMP),'PST') AT TIME ZONE 'EST5EDT' FROM DUAL;

```

Which outputs:

> 
> 
> ```
> 
> | FROM_TZ(CAST(SYSDATEASTIMESTAMP),'PST')ATTIMEZONE'EST5EDT' |
> | :--------------------------------------------------------- |
> | 02-APR-21 11.07.33.000000 PM EST5EDT                       |
> 
> ```
> 
> 

or:

```sql
SELECT from_tz(CAST(sysdate AS TIMESTAMP),'US/Pacific') AT TIME ZONE 'US/Eastern' FROM DUAL;

```

Which outputs:

> 
> 
> ```
> 
> | FROM_TZ(CAST(SYSDATEASTIMESTAMP),'US/PACIFIC')ATTIMEZONE'US/EASTERN' |
> | :------------------------------------------------------------------- |
> | 02-APR-21 11.07.33.000000 PM US/EASTERN                              |
> 
> ```
> 
> 

*db<>fiddle [here](https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=d5f2a83874b278412b0596443eb29d4c)*