Delete a row based on a full date yyyy-mm-dd using delete and where-CodePudding

Home > database > Delete a row based on a full date yyyy-mm-dd using delete and where

Delete a row based on a full date yyyy-mm-dd using delete and where

Time：09-09

How can I delete a row in PostgreSQL where the date is yyyy-mm-ddd using delete and where

I tried to use this formula ="DELETE FROM table WHERE date="&A2& the date changed from 2005-1-1 to 38383

CodePudding user response：

It looks like you generated the &A2& with excel. If that is the case you want excel to do the formatting:

=TEXT(A2;"YYYY-MM-DD") .

If not you probably need to cast the date explicitly to a date