Ask a Question related to Macromedia Dynamic HTML, Design and Development.
-
bigforehand #1
Converting Date
In PHP with MySQL:
My table stores the date as 2003/10/07 ... (year, day, month). I want to be able to convert it to 07/10/2003 before I echo it out to the screen. Not sure how to do this?
Thanks
----
Rob Maguire
Web Development
bigforehand Guest
-
ASP integer date/time converting problems
Hi Rob, This is definitely not a UTC conversion. I don't know what kind of notation it is. The best way to converting this date is by using your... -
Converting Date Formats?
Howdy! I have some dates in a MySQL database that are in a 'Y-m-d' format. Is there a way to have PHP read these dates and convert them to a... -
Converting a text field to a date field - FM6
I need to convert a Text field containing both auto and manually entered dates over to a Date field. The records that were autoentered move over... -
converting date into database date format(newbie)
Hi! U can convert "8-Aug-03" into mysql date which requires yyyy-mm-dd format as below. <?php date("Y-m-d",strtotime("8-Aug-03")); ?> -
Converting raw numbers to written date
How would you decipher a stamp like 12303 Is it 1/23/03 or 12/3/03 ------------------------------------------------- d l b j r Unambit... -
MMontero - MMTS #2 Re: Converting Date
Try this php code:
<?php echo date("m/d/Y", strtotime($row_Recordset1['FIELD2'])); ?>
I hope this helps.
--
Best regards,
Mike M
Macromedia Technical Support
Dreamweaver UltraDev / MX
Search the Support Site -
[url]http://www.macromedia.com/support/ultradev/[/url]
[url]http://www.macromedia.com/support/dreamweaver/[/url]
Macromedia Newsgroups -
[url]http://webforums.macromedia.com/dreamweaverultradev/[/url]
[url]http://webforums.macromedia.com/dreamweaver/[/url]
"bigforehand" <lobber1_guy@yahoo.com> wrote in message
news:bepd70$p6u$1@forums.macromedia.com...be able to convert it to 07/10/2003 before I echo it out to the screen. Not> In PHP with MySQL:
>
> My table stores the date as 2003/10/07 ... (year, day, month). I want to
sure how to do this?>
> Thanks
>
> ----
> Rob Maguire
> Web Development
MMontero - MMTS Guest
-
MMontero - MMTS #3 Re: Converting Date
BTW, there's a TechNote about this:
Formatting date and time values in PHP
[url]http://www.macromedia.com/support/dreamweaver/ts/documents/php_date_format.h[/url]
tm
--
Best regards,
Mike M
Macromedia Technical Support
Dreamweaver UltraDev / MX
Search the Support Site -
[url]http://www.macromedia.com/support/ultradev/[/url]
[url]http://www.macromedia.com/support/dreamweaver/[/url]
Macromedia Newsgroups -
[url]http://webforums.macromedia.com/dreamweaverultradev/[/url]
[url]http://webforums.macromedia.com/dreamweaver/[/url]
"MMontero - MMTS" <supportinfo@macromedia.com> wrote in message
news:bf18d3$726$1@forums.macromedia.com...Not> Try this php code:
>
> <?php echo date("m/d/Y", strtotime($row_Recordset1['FIELD2'])); ?>
>
> I hope this helps.
> --
>
> Best regards,
>
> Mike M
> Macromedia Technical Support
> Dreamweaver UltraDev / MX
>
> Search the Support Site -
> [url]http://www.macromedia.com/support/ultradev/[/url]
> [url]http://www.macromedia.com/support/dreamweaver/[/url]
>
> Macromedia Newsgroups -
> [url]http://webforums.macromedia.com/dreamweaverultradev/[/url]
> [url]http://webforums.macromedia.com/dreamweaver/[/url]
>
> "bigforehand" <lobber1_guy@yahoo.com> wrote in message
> news:bepd70$p6u$1@forums.macromedia.com...> be able to convert it to 07/10/2003 before I echo it out to the screen.> > In PHP with MySQL:
> >
> > My table stores the date as 2003/10/07 ... (year, day, month). I want to> sure how to do this?>> >
> > Thanks
> >
> > ----
> > Rob Maguire
> > Web Development
>
MMontero - MMTS Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
