PHP Update Query Date is not inserted?

Question

Hello Friends this is my update query.

UPDATE bizz_investor_form set    
  Published_Published='publishedyes',
  Published_Listed_and_Discoverable='listedanddiscoverableno',
  Published_Describe_Start_Date='21-10-2013',
  Describe_end_Date='30-10-2013' 
WHERE user_id =136

When i run that query the date put in database like 0000-00-00 please help any one.

What field type is your date field in your database? DATE? Try changing the format to YYYY-MM-DD — ɴᴀᴛᴇ ᴅᴇᴠ
– ɴᴀᴛᴇ ᴅᴇᴠ, Commented Oct 21, 2013 at 8:06
Maybe it's month-day-year or year-month-day, check the order — Donovan Charpin
– Donovan Charpin, Commented Oct 21, 2013 at 8:07
In mysql date type datatype fields take value as '2013-10-30' (yyyy-mm-dd) — Deepika Janiyani
– Deepika Janiyani, Commented Oct 21, 2013 at 8:09

tCode · Accepted Answer · 2013-10-21 08:08:26Z

2

Datetime format in mysql is YYYY-MM-DD H:i:s (2013-10-30 11:08:55)

answered Oct 21, 2013 at 8:08

tCode

4343 silver badges8 bronze badges

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

Comments

Renish Khunt · Accepted Answer · 2013-10-21 08:16:41Z

0

Change date to like.

$startdate = date("Y-m-d",strtotime('21-10-2013'));
$enddate = date("Y-m-d",strtotime('21-10-2013'));

then after write your query like.

"UPDATE bizz_investor_form set    
  Published_Published='publishedyes',
  Published_Listed_and_Discoverable='listedanddiscoverableno',
  Published_Describe_Start_Date='".$startdate."',
  Describe_end_Date='".$enddate."' 
WHERE user_id =136"

answered Oct 21, 2013 at 8:16

Renish Khunt

5,83418 gold badges58 silver badges93 bronze badges

Comments

CreatoR · Accepted Answer · 2013-10-21 08:09:26Z

0

Set field type to DATE or change value to 2013-10-30 00:00:00 (mysql dates format yyyy-mm-dd hh:mm:ss)

answered Oct 21, 2013 at 8:09

CreatoR

1,65210 silver badges14 bronze badges

Comments

Donovan Charpin · Accepted Answer · 2013-10-21 08:17:11Z

0

MySQL's default DATE field format is YYYY-MM-DD.

You can use DATE_FORMAT

DATE_FORMAT('1997-10-04 00:00:00', '%W %M %Y');

edited Oct 21, 2013 at 8:17

answered Oct 21, 2013 at 8:10

Donovan Charpin

3,40725 silver badges30 bronze badges

Collectives™ on Stack Overflow

PHP Update Query Date is not inserted?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related