In this tutorial article, we will learn how to use the PostgreSQL CURRENT_TIMESTAMP Function skillfully through some workflow examples. The syntax looks like this: CURRENT_TIMESTAMP(precision) The PostgreSQL Current_Timestamp Function helps you find the same with precision up to 6 decimal places. For instance, you would want the exact time a transaction would have started. By default, the output value only goes up to 6 decimal places.Īn easier way to understand would be through an example. As the name would suggest, the Precision argument results in the time value output with a fractional second accuracy. In addition, the function query also takes in an optional argument, Precision.
PostgreSQL CURRENT_TIMESTAMP vs LOCALTIMESTAMP.