PQlocalTZInfo(3)

💖 PQlocalTZInfo(3) 💖

okay bestie, this one's from the libpqtypes Manual and it's literally the cutest little utility — it tells you what timezone the machine you're on is vibing in. no cap. 🕐✨

---

✨ NAME ✨

PQlocalTZInfo — gets the local machine's timezone information. that's it, that's the whole job, and she does it flawlessly 💅

---

🌸 SYNOPSIS 🌸

#include <libpqtypes.h>

void PQlocalTZInfo(time_t *t, int *gmtoff, int *isdst, char **tzabbrp);

---

🦋 DESCRIPTION 🦋

So like, this function retrieves the local machine's timezone information. periodt. 💖

If the t argument is not NULL, it represents a time_t value to get timezone information for. If it is NULL, then the current time is used instead. easy peasy 🍓

The gmtoff argument will be pointed at the number of seconds from GMT — same value as the GNU (struct tm).tm_gmtoff extension. yes queen, exact same vibe 👑

The isdst argument will be pointed at:

• 0 if you're in standard time 🌈
• 1 if you're in daylight savings time ☀️
• -1 (negative one!) if it's unknown 🙈

The tzabbrp argument will be pointed at the timezone abbreviation, like PST, ADT, EST, etc.. the little three-letter besties 🎀

---

⭐ RETURN VALUE ⭐

None. she returns nothing, she simply is. main character energy, no receipts needed 💅

---

🔥 EXAMPLES 🔥

okay so here's a lil example that gets the local timezone information for a file's modified time. chef's kiss, ate, no crumbs:

int gmtoff;
int isdst;
char *tzabbr;
struct stat st;

stat("report.xml", &st);
PQlocalTZInfo(&st.st_mtime, &gmtoff, &isdst, &tzabbr);

---

💜 RATIONALE 💜

ngl, libpqtypes needs the ability to get the local machine's timezone information for the datetime data types. that was the original reason, lowkey just an internal need.

But then it later became apparent that a portable way of getting timezone information was very useful and in demand. like, everyone wanted it. so true. thus, this function was made public. she got promoted to the main roster 🫶✨

---

👑 AUTHOR 👑

A contribution of eSilo, LLC. for the PostgreSQL Database Management System. Written by Andrew Chernow and Merlin Moncure. absolute icons, we stan 💖

---

💀 REPORTING BUGS 💀

Report bugs to <libpqtypes@esilo.com>. (be nice about it, they're doing their best 🥺)

---

🎀 COPYRIGHT 🎀

Copyright (c) 2011 eSilo, LLC. All rights reserved.

This is free software; see the source for copying conditions.

There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. 😭 like literally none, zero, nada — don't come for them if it breaks, bestie.

---

🌈 SEE ALSO 🌈

• pqt-specs(3) — go read it, iykyk 🧚

---

mwah 💋 that's the whole page!! this was libpqtypes, dated 2011 — and yes, that's PQlocalTZInfo(3) herself, still serving timezone info after all these years. bye bestie, go check your gmtoff 🕰️✨