Toolset

[Resolved] What exactly does the TODAY() function returns? the today of what time zone?

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	10:00 – 13:00	-
-	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	14:00 – 18:00	-

Supporter timezone: Asia/Kolkata (GMT+05:30)

This topic contains 1 reply, has 2 voices.

Last updated by Minesh 3 months ago.

Assisted by: Minesh.

Author

Posts

January 22, 2024 at 2:40 pm #2679472

sorinR

Screenshot 2024-01-22 at 16.37.20.png

Hi,

I have a view that has a condition that is based on the today() function.

Please see he attached file.

The thing is that today is 22 of January in Bucharest and Romania.

But the view acts like is 21 of January.

It shows something that has 21 january date.

What is the issue?

Today() returns what timezone day? From what country?

January 23, 2024 at 11:59 am #2679608

Minesh

Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello. Thank you for contacting the Toolset support.

Toolset stores date value as Unix timestamp without converting to UTC for a reason you can read with the following errata page:
- https://toolset.com/errata/toolset-date-field-stores-local-time-in-the-database-instead-of-utc/

Here is the related ticket that might help you where custom shortcode shared that might help you to display correct date:
- https://toolset.com/forums/topic/universal-time-for-toolset-date-field-in-wordpress-admin/page/2/#post-2639189

More related ticket:
- https://toolset.com/forums/topic/can-a-date-time-field-be-modified-based-on-the-users-timezone/
- https://toolset.com/forums/topic/universal-time-for-toolset-date-field-in-wordpress-admin/

This ticket is now closed. If you're a WPML client and need related help, please open a new support ticket.