Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/#!/StackDBAs/status/458070500330446849
add tags, minor edits
Source Link
Erwin Brandstetter
Erwin Brandstetter
  • 186.6k
  • 28
  • 465
  • 639

difference Difference between now() and current_timestamp

In postgresqlPostgreSQL, I use the now()now() and current_timestampcurrent_timestamp function and I see no difference:

# SELECT now(), current_timestamp; now | now --------------------------------+-------------------------------- 04/20/2014 19:44:27.215557 EDT | 04/20/2014 19:44:27.215557 EDT (1 row)

Am I missing something?

difference between now and current_timestamp

In postgresql, I use the now() and current_timestamp function and I see no difference:

# SELECT now(), current_timestamp; now | now --------------------------------+-------------------------------- 04/20/2014 19:44:27.215557 EDT | 04/20/2014 19:44:27.215557 EDT (1 row)

Am I missing something?

Difference between now() and current_timestamp

In PostgreSQL, I use the now() and current_timestamp function and I see no difference:

# SELECT now(), current_timestamp; now | now --------------------------------+-------------------------------- 04/20/2014 19:44:27.215557 EDT | 04/20/2014 19:44:27.215557 EDT (1 row)

Am I missing something?

Source Link
JohnMerlino
JohnMerlino
  • 1.9k
  • 5
  • 20
  • 21

difference between now and current_timestamp

In postgresql, I use the now() and current_timestamp function and I see no difference:

# SELECT now(), current_timestamp; now | now --------------------------------+-------------------------------- 04/20/2014 19:44:27.215557 EDT | 04/20/2014 19:44:27.215557 EDT (1 row)

Am I missing something?