Skip to main content

Return to Answer

added 35 characters in body
Source Link
John Sonnino
John Sonnino
  • 579
  • 6
  • 10

Just do:

SELECT CAST(date_variable AS date)

or with with PostgreSQL:

SELECT date_variable::date

This is called typecasting btw!

Just do:

SELECT CAST(date_variable AS date)

or with with PostgreSQL:

SELECT date_variable::date

Just do:

SELECT CAST(date_variable AS date)

or with with PostgreSQL:

SELECT date_variable::date

This is called typecasting btw!

added 7 characters in body
Source Link
John Sonnino
John Sonnino
  • 579
  • 6
  • 10

I don not know what is up with all these answers and nothing simple.Just do:

Just doSELECT CAST(date_variable AS date)

or with with PostgreSQL:

SELECT date_variable::date

I don not know what is up with all these answers and nothing simple.

Just do:

SELECT date_variable::date

Just do:

SELECT CAST(date_variable AS date)

or with with PostgreSQL:

SELECT date_variable::date

Source Link
John Sonnino
John Sonnino
  • 579
  • 6
  • 10

I don not know what is up with all these answers and nothing simple.

Just do:

SELECT date_variable::date