Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Date conversions ( date, mktime )
March 12, 2007, 5:56 pm
rate this thread
I have a date in three pieces dd mm yyyy.
I'm just wondering the best way to convert this for inserting into a
DATETIME field and then back again when displaying it.
I have tried date, strtotime mktime but it keeps inserting a blank
date. i.e. 00:00:00 00:00...
I've been looking through the php manual but I can't seem to get this
Also would I be better off using the UNIX_TIMESTAMP function?
Thanks in advance.
Re: Date conversions ( date, mktime )
You don't need to convert it. If you have three variables, for example
$year, $month and $day, all you need to do is this:
"INSERT INTO sometable (..., mydatefield) VALUES
There are better ways of doing this but at its most simple that will
work. Of course you need to be aware of sql injection if your values
come from a form post, and the $month and $day variables need to be
To then utilise the database value from your SELECT query you can use
strtotime() to convert it to a timestamp and date() to format you as
you require, but there are limitations on the date range. You may be
better to use the database's date formatting functions to have it
formatted as you would like it displayed.
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com
- » ssh on command line: force using a group size (prime size) of 1024 (and no...
- — The site's Newest Thread. Posted in » Secure Shell Forum