Saying time is important is to state the obvious. Our lives are built on time. We only have so much of it and once it is gone, there is no getting it back. While not as important as that time, date and time data values are integral pieces in most –if not all– database infrastructure and design. At some point or another, date and time values must be considered. PostgreSQL has many functions and options for date and time value manipulation. In this post, I look at the INTERVAL
type for date and time calculations….
Content
The EXTRACT() function with examples in PostgreSQL
At times, you may only need a certain portion of a date interval or TIMESTAMP
. Luckily in PostgreSQL, we have the EXTRACT()
function that allows you to grab just those particular bits of data. See how with a few simple examples in this post…
CURSOR errors without HANDLER’s in MySQL – with examples.
In one of my previous posts, CONTINUE HANDLER in MySQL – One way, with examples, I hinted at a forthcoming piece on the topic of using a CURSOR
without a CONTINUE HANDLER
. Read on and learn the exact error you should see and more importantly, what it means.
CONTINUE HANDLER in MySQL – One way, with examples.
In this blog post, we will visit an alternate CONTINUE HANDLER
declaration I recently learned about while studying CURSOR
‘s in MySQL.
Example of the RENAME USER command in MySQL
Naming your users and specifying their host does not have to be permanent. However, to implement any changes to those two fields, it is better to use the RENAME USER
command as opposed to directly updating MySQL system tables. Read on to learn about this command with me…