Relative Content

Monthly Archives: September 2017

Postgresql Time (epoch)

In addition to standard timestamps we can also ask postgres to return the number of seconds from the epoch.  To the uninitiated the epoch is usually the number of seconds past a fixed point in time (usually, but not always, midnight on 01/01/1970).  If you would like to know when the epoch is on your […]

SQL Time stamps

Throughout my program I use time stamps all over the place for all sorts of different purposes in all sorts of different formats.  This post is to give you an overview of the basics.  There is no C++ or Ncurses code here, any of the code is commands that can be typed at a psql […]

Overloading functions when using time_t

One of the problems that we have when using postgresql is the management of time stamps.  This is especially true when using PQexecparams() for reasons that I will not go in to in this post; suffice it to say that when building INSERT statements that use time stamps you may need to get creative. One […]