to_date function issue in PostgreSQL

Question

I have a PostgreSQL table with a column name date_stamp and its data type is "date".
I need to execute the below query and it's not working. Can anyone help? Thank You.
(I am using PHP)

$DS = date('d m Y' ,$data['time_stamp']);       

$query = "SELECT id from ".$this->table_ud." WHERE user_id=43 AND date_stamp=to_date(".$DS.",YYYY MM DD)";

Got the answer. The problem was not with PostgreSQL. to_date() works just fine. — Les_Salantes
– Les_Salantes, Commented Aug 2, 2012 at 9:14

xdazz · Accepted Answer · 2012-08-02 08:46:38Z

1

Not necessary to use to_date.

You could just do with:

$DS = date('Y-m-d' ,$data['time_stamp']);       
$query = "SELECT id from ".$this->table_ud." WHERE user_id=43 AND date_stamp='$DS'";

answered Aug 2, 2012 at 8:46

xdazz

161k38 gold badges255 silver badges278 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Les_Salantes Over a year ago

are u sure that to_date() is not necessary? Initially I tried to do what you have suggested above and it didn't work. My guess was that php date() function returns a string and the date_stamp column in the table is of type date and that you cannot compare a string type with date.

Collectives™ on Stack Overflow

to_date function issue in PostgreSQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related