do not truncate my date please!!

tomboy78

I try to $_post the value from a selected day in a calendar using checkbox and then insert into oracle db.

The problem I'm having is that when I try to insert into the database eg 1st january 2003 PHP only gives me 1103 instead of 010103. So PHP deletes the zero before the day and the month. When I choose a day with 2 digit day and month eg. 25th of December (251203) it works fine.

How can I make PHP not truncate my date?

this is my check box in the calendar code:

[code=php]
[code=php]
<input type='checkbox' name='cb".$sequence[$day]."'value =".$sequence[$day].$month.$year.">

and this is the way i get the values and insert into oracle:

[code=php]
[code=php]
for ($i=0; $i<=31;$i++) { 
         $date = $_POST['cb'.$i]; 

     print $date; 


$sql_day="insert into holiday_days values($hol_dayid_seq, $input, to_date('$date','DDMMYY'))";

Is there a way to tell PHP NOT to truncate?
thanks for your help

okuto1973

Are you sure that you can insert in oracle db the date in that format?
Try to change the format to YYYY-mm-dd
where
YYYY=Year,mm the month and dd the day like this:
2003-07-11

tomboy78

yes you can insert into oracle like that because I tell oracle in what format I will pass it as with the to_date command.

In my code you see: to_date('$date','DDMMYY')

here I say take $ date (eg 151203) and it is in the DDMMYY format. But in fact in the DB it is actually stored as 15-dec-03.

I know that works because I am inserting into the DB where I pass on doble digit date ie 151203 and not single digit ie 010103.

if only I could tell PHP not to remove that zero!!

cahva

You can use sprintf-function to format your strings.

In your case:

$date=sprintf("%02d%02d%02d",$sequence[$day],$month,$year);

tomboy78

Thanks alot cahva!
that sprintf function did the trick.