What constant to declare in PDO::PARAM_ to insert date (yyyy-mm-dd h::m:s) in mysql?

Question

What constant to declare in PDO::PARAM_ to insert date (yyyy-mm-dd h::m:s) in mysql?

Asked 7 years, 10 months ago

Viewed 171 times

1

I need to pass a date to the database. I will use the PDO class, but I have the following question. When creating "bindValue()" what kind of constant should I declare in PDO::PARAM_ ?

2

PDO::PARAM_STR that one

– novic

2017/01/06 at 00:49
1

String constant ?

– ayelsew

2017/01/06 at 00:59
2

is yes to save dates in format yyyy-mm-dd h:m:s or yyyy-mm-dd in the PDO is PDO::PARAM_STR only remembering that the date has to be in the format that the bank accepts ...

– novic

2017/01/06 at 01:00

1 answer

Browser other questions tagged php mysql pdo

You are not signed in. Login or sign up in order to post.

by Gabriel Heming • **2,479** points · Answer 1 · 2017-01-06T00:59:22+00:00

For dates, always the default, which is PDO::PARAM_STR. Anyway, when you write a normal query, the date is sent as string.

https://stackoverflow.com/questions/2374631/pdoparam-for-dates