Date with 'Zeros' Output

Question

rakwel10 0 Junior Poster in Training

13 Years Ago

I have a date picker that give me this result: e.g. 2011-29-08
When it is inserted in mysql, it outputs '0000-00000'.
What can I do?

I know "strftime("%Y-%m-%d %H:%M:%S", time());"
But I have no timestamp to put as an argument.
The only data I can use is the data that the date picker produces (yyyy-dd-mm)

Whats the proper thing to do?
I'll wait for your replies. Thanks!

php

5 Contributors
20 Replies
139 Views
10 Hours Discussion Span
Latest Post 13 Years Ago Latest Post by rakwel10

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

actually your format is yyyy-dd-mm

so change your strftime like

strftime("%Y-%d-%m", $datevariable);"

or change your date picker setting to yyyy-mm-dd, then you can directly insert date variable without strftime.

Ichcha 0 Light Poster

13 Years Ago

try

$insertDate  = date("Y-m-d",strtotime($date))

karthik_ppts 81 Posting Pro

13 Years Ago

better make your date picker code to show the date in YYYY-MM-DD forma

urtrivedi 276 Nearly a Posting Virtuoso

13 Years Ago

you must wrap around single quotes

....,'$initial_date',.....

karthik_ppts commented: helpful reply +6

karthik_ppts 81 Posting Pro

13 Years Ago

put single quotes for the value of the date in the query

INSERT INTO tbl_tour_profile ( `tour_code`, `tour_name`, `subj_code`, `subj_name`, `section`, `subj_teacher`, `destination`, `date`, `path`, `tour_amount`, `expected_num_participants`, `estimated_tour_budget`)
VALUES ('10006', 'Tour MIS', 2122, '6MIS', 'N-201', ' Maria Allen J. Quiambao', 'HAU', '2011-08-31', 'tourdocs/10006_Doc1.doc','234','234','54756')

Edited 13 Years Ago by karthik_ppts because: n/a

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

rakwel10 0 Junior Poster in Training · Answer 1 · 2011-08-29T11:37:06+00:00

Thanks for you reply...

I still get zeros...

this is my code

$initial_date = mysql_prep($_POST['date']);
$date = strftime("%Y-%d-%m", $initial_date);

"$_POST" has data = yyyy-dd-mm

Pls help. tnx

rakwel10 0 Junior Poster in Training · Answer 2 · 2011-08-29T12:19:37+00:00

it does displays yyyy-dd-mm.

but when i insert it in mysql (the data type of the column is 'Date'),
it still returns zeros :(

karthik_ppts 81 Posting Pro · Answer 3 · 2011-08-29T12:31:27+00:00

it does displays yyyy-dd-mm.
but when i insert it in mysql (the data type of the column is 'Date'),
it still returns zeros :(

change the format to yyyy-mm-dd in your input

urtrivedi 276 Nearly a Posting Virtuoso · Answer 4 · 2011-08-29T12:51:30+00:00

I think you do not need mysql_prep

try following code without mysql_prep

$initial_date = $_POST['date'];

rakwel10 0 Junior Poster in Training · Answer 5 · 2011-08-29T13:07:04+00:00

I did all what you've suggested...
I remove the mysql_prep, rearrange the month and day and others...
Still it didnt work...

I tested the value of "$_POST;" before inserting in mysql.
The date alerted right (2011-08-29). Sadly, when inserted to mysql, zeros are still there...

Any other options? what do you think?
thanks for your help by the way..

urtrivedi 276 Nearly a Posting Virtuoso · Answer 6 · 2011-08-29T13:10:08+00:00

echo $query before execution and copy it and run in phpmyadmin.
also post that output query here.

rakwel10 0 Junior Poster in Training · Answer 7 · 2011-08-29T13:23:02+00:00

Here is the query..

INSERT INTO tbl_tour_profile ( `tour_code`, `tour_name`, `subj_code`, `subj_name`, `section`, `subj_teacher`, `destination`, `date`, `path`, `tour_amount`, `expected_num_participants`, `estimated_tour_budget`)
VALUES ('10006', 'Tour MIS', 2122, '6MIS', 'N-201', ' Maria Allen J. Quiambao', 'HAU', 2011-08-31, 'tourdocs/10006_Doc1.doc','234','234','54756')

as you can see, the date format is right (yyy-mm-dd).
Is the problem in mysql?

rakwel10 0 Junior Poster in Training · Answer 8 · 2011-08-29T13:33:38+00:00

initial_date is not part of the query coz its not in the field. Do you mean date?
...`subj_teacher`, `destination`, `date`,...

It does have quotes. Actually, I copied sql query in phpmyadmin.

rakwel10 0 Junior Poster in Training · Answer 9 · 2011-08-29T14:02:16+00:00

in my desperate situation,
I tried changing the "date" datatype into a varchar or text.
The result is surprising and WEIRD...
It gave me a year - "1972".
Weird isnt it? Do you think mysql is the problem?

diafol · Answer 10 · 2011-08-29T14:23:31+00:00

@KP - 1 for your patience!

rakwel10 0 Junior Poster in Training · Answer 11 · 2011-08-29T14:47:35+00:00

KP,

the one with the red mark, thats the value of date field and it has quotes on it. what do you think?

INSERT INTO tbl_tour_profile ( `tour_code`, `tour_name`, `subj_code`, `subj_name`, `section`, `subj_teacher`, `destination`, `date`, `path`, `tour_amount`, `expected_num_participants`, `estimated_tour_budget`)
VALUES ('10006', 'Tour MIS', 2122, '6MIS', 'N-201', ' Maria Allen J. Quiambao', 'HAU', '2011-08-31', 'tourdocs/10006_Doc1.doc','234','234','54756')

urtrivedi 276 Nearly a Posting Virtuoso · Answer 12 · 2011-08-29T14:50:09+00:00

you need to quote around date and text, only numbers are allowed to write without qoutes

so
1) do not change your datatype
2) post your query (not output) only php mysql query with variables names, i will prepare query for you.

rakwel10 0 Junior Poster in Training · Answer 13 · 2011-08-29T15:12:24+00:00

Here it is...

" INSERT INTO tbl_tour_profile ( `tour_code`, `tour_name`, `subj_code`, `subj_name`, 	 
`section`, `subj_teacher`, `destination`, `date`,  `path`, `tour_amount`, `expected_num_participants`, `estimated_tour_budget`) 
VALUES ('$tourId', '{$tourName}', {$classCode}, '{$subject}',  '{$section}', '{$teacher}', '{$destination}', {$date}, '{$path}','{$amount}','{$expected_num_participants}','{$estimated_tour_budget}')";

karthik_ppts 81 Posting Pro · Answer 14 · 2011-08-29T15:14:23+00:00

" INSERT INTO tbl_tour_profile ( `tour_code`, `tour_name`, `subj_code`, `subj_name`,
    `section`, `subj_teacher`, `destination`, `date`, `path`, `tour_amount`, `expected_num_participants`, `estimated_tour_budget`)
    VALUES ('$tourId', '{$tourName}', {$classCode}, '{$subject}', '{$section}', '{$teacher}', '{$destination}', '{$date}', '{$path}','{$amount}','{$expected_num_participants}','{$estimated_tour_budget}')";

rakwel10 0 Junior Poster in Training · Answer 15 · 2011-08-29T15:18:37+00:00

woooooaaaaaaahhhhhhhh!!!!!! I GOT IT!!!!!!! Thanks to you and to others who patiently commented!!!!