 |  |  |  |  |  |  |  |
DATE problem
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
I Need to insert a date into mysql database i dont know which is better
using DATE or VARCHAR as the date field ??
im using now the DATE type but whenever i insert any date its not inserted in the DB
0000-00-00 it appears like this .
the Code:
$mydate=date("$year.$month.$day");
insert into ....values ($mydate);
i dont know what's wrong
plz help
using DATE or VARCHAR as the date field ??
im using now the DATE type but whenever i insert any date its not inserted in the DB
0000-00-00 it appears like this .
the Code:
$mydate=date("$year.$month.$day");
insert into ....values ($mydate);
i dont know what's wrong
plz help
•
•
Join Date: Jun 2008
Posts: 849
Reputation: 
Solved Threads: 67
Practically a Posting Shark
•
•
•
•
Originally Posted by yasmena 
I Need to insert a date into mysql database i dont know which is better
using DATE or VARCHAR as the date field ??
im using now the DATE type but whenever i insert any date its not inserted in the DB
0000-00-00 it appears like this .
the Code:
$mydate=date("$year.$month.$day");
insert into ....values ($mydate);
i dont know what's wrong
plz help
“Be who you are and say what you feel because those who mind don't matter and those who matter don't mind.” - Dr. Seuss
-- The documentation is inevitable, you may get away with it for a little while but eventually you too will have to do the deed.
-- The documentation is inevitable, you may get away with it for a little while but eventually you too will have to do the deed.
•
•
Join Date: Jul 2004
Posts: 234
Reputation:
Solved Threads: 8
Posting Whiz in Training
Replace dots with dashes. Try below.
php Syntax (Toggle Plain Text)
•
•
Join Date: Jul 2008
Posts: 1,076
Reputation:
Solved Threads: 98
what error you got?????
Be intelligent, But Don't try to cheat.. Be innocent But Don't get cheated..
I think there is problem in inserting the values into database can you once check the syntax of insert query or if you provide the query i will look into it
Regardless of what the error is I find it best to store a unix timestamp in the database in a "int" field and then use PHP to manipulate it.
This produces a very fast db table when sorting by date.
This is the best practice until you become more familiar with php and mysql and explore the differences in formatting the date.
To get the unix timestamp do something like:
you can then format this by doing:
Very simple.
This produces a very fast db table when sorting by date.
This is the best practice until you become more familiar with php and mysql and explore the differences in formatting the date.
To get the unix timestamp do something like:
PHP Syntax (Toggle Plain Text)
PHP Syntax (Toggle Plain Text)
U know Thanks So much i solved the problem
but now i faced another
when the date is displayed its displayed YYYY-MM-DD
is their anyother way to display it as DD-MM-YYYY ?????????????????
if im storing as DATE
but now i faced another
when the date is displayed its displayed YYYY-MM-DD
is their anyother way to display it as DD-MM-YYYY ?????????????????
if im storing as DATE
•
•
Join Date: Jul 2004
Posts: 234
Reputation:
Solved Threads: 8
Posting Whiz in Training
php Syntax (Toggle Plain Text)
Thank You Very Much POA
but may i ask why are u using
strtotime here ?? why not just say
$newDate=date('d-m-Y');
but may i ask why are u using
strtotime here ?? why not just say
$newDate=date('d-m-Y');
•
•
Join Date: Jun 2008
Posts: 849
Reputation:
Solved Threads: 67
Practically a Posting Shark
•
•
•
•
Originally Posted by yasmena
Thank You Very Much POA
but may i ask why are u using
strtotime here ?? why not just say
$newDate=date('d-m-Y');
“Be who you are and say what you feel because those who mind don't matter and those who matter don't mind.” - Dr. Seuss
-- The documentation is inevitable, you may get away with it for a little while but eventually you too will have to do the deed.
-- The documentation is inevitable, you may get away with it for a little while but eventually you too will have to do the deed.
|
Similar Threads
- date problem (Visual Basic 4 / 5 / 6)
- Small date problem (ASP)
- Dreamweaver MX2004 & date problem, etc. (Graphics and Multimedia)
- Access Date Problem (Computer Science)
- Hi Access Date Problem (> Now +7 Days And < Now +2 Months) (Computer Science)
- Date Problem (JSP)
Other Threads in the PHP Forum
- Previous Thread: How to retrieve .doc or .jpeg file from FTP server
- Next Thread: pliz help
Views: 714 | Replies: 9
| Thread Tools | Search this Thread |
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for PHP
.htaccess access ajax apache api array autosuggest beginner binary broken cakephp checkbox class cms code cron curl database date directory display download dynamic echo email emptydisplayvalue error explodefunction file files folder form forms function functions google href htaccess html image include insert integration ip java javascript joomla jquery keywords limit link login loop mail menu methods mlm mod_rewrite multiple mysql oop parse paypal pdf php problem query radio random recursion regex remote script search searchbox select server sessions sms soap source space speed sql structure syntax system table tutorial update updates upload url validation validator variable video web xml youtube
