Converting dates

How to convert a MySQL date (YYYY-MM-DD HH-MM-SS) into the PHP format?

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Converting dates

PHP mainly works using UNIX like timestamps, that are based on large
numbers that represents the number of seconds since the "UNIX start
time" (don't remember exactly what it is). You can use the mktime()
function to build timestamps based on info that you get from MySQL.

Hope that helps,


On Fri, 4 Mar 2005 16:46:39 -0300, jakexblaster@google
wrote:
> How to convert a MySQL date (YYYY-MM-DD HH-MM-SS) into the PHP format?
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
>
>


--
Daniel da Veiga
Computer Operator - RS - Brazil

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Converting dates

mySql Function to convert dates into unixtime: UNIX_TIMESTAMP(date_column)
mySql Function to convert unixtime to date: FROM_UNIXTIME(unixtime_column)

Randy Clamons
Systems Programming
Novaspace.com


> ------------Original Message------------
> From: Daniel da Veiga
> To: "MySQL Win32 List"
> Date: Fri, Mar-4-2005 12:55 PM
> Subject: Re: Converting dates
>
> PHP mainly works using UNIX like timestamps, that are based on large
> numbers that represents the number of seconds since the "UNIX start
> time" (don't remember exactly what it is). You can use the mktime()
> function to build timestamps based on info that you get from MySQL.
>
> Hope that helps,
>
>
> On Fri, 4 Mar 2005 16:46:39 -0300, jakexblaster@google
> wrote:
> > How to convert a MySQL date (YYYY-MM-DD HH-MM-SS) into the PHP
> format?
> >
> > --
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:
> http://lists.mysql.com/win32?unsub=danieldaveiga@gmail.com
> >
> >
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:
> http://lists.mysql.com/win32?unsub=randy@novaspace.com
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org