Subject: Re: How to emulate a DATE() in MySQL 4.0?

Mailing List

Home

Forum Home

MySQL General - General MySQL discussion

MySQL++ - Programming with the C++ API to MySQL

MaxDB - Everything about MaxDB, formerly known as SAP DB

ODBC - ODBC with the MySQL Connector/ODBC driver

MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP

Java Help - Mostly related to the MySQL Connector/J driver

Perl - Perl support for MySQL with DBI and DBD::mysql

GUI - MySQL GUI Tools

Announcement

Subjects

•	Subject: mysql openssl Question
•	ERROR 1045: Access denied for user: 'root@localhost ' (Using password: NO)
•	Update one field with more fields from another table
•	Subject: Getting Identity after INSERT
•	ERROR 2002: Can 't connect to local MySQL server through socket
•	mysql test 4 1 fails with the gis test
•	Subject: MySQL Cluster Software
•	Downgrade Mysql from 4 to 3 23
•	Mysql 4 0 Oracle Stored Procedure Trigger Conversion
•	Can 't access mysql after kernel upgrade
•	Executing MySQL Commands From Within C Program
•	Comparing and writing out BLOBS
•	Subject: Re: Preventing Duplicate Entries
•	FULLTEXT query format question
•	Strange behavior, Table Level Permission
•	Does the binary log enabling affect the MySQL performances?
•	mysql:it 's a db not a dbms how it 's possible?!
•	mysql have same function mthod as Oracle decode()

Subject: Re: How to emulate a DATE() in MySQL 4.0?

Subject: Re: How to emulate a DATE() in MySQL 4.0?

2007-11-03 - By Baron Schwartz

Back
mikesz@(protected) wrote:
> Hello mysql,
>
> I have a PHP script that I have written and it runs beautifully on
> current MySQL and PHP sites BUT, it barfs on MySQL 4.0 because I am
> using the DATE() to extract the Date from a timestamp. Does anyone
> remember how to do an equivalent function in 4.0? I have searched
> through hundreds of pages and can not find anything that looks like it
> might work. Essentially I need to extract the YYYY-MM-DD from a
> timestamp field that I populated in a PHP script so I can do a diff
> against a current timestamp.
>
> Here is the query that works on current and falls over dead on 4.0:
>
> "SELECT count(SimulatedTimeSet) as count_live FROM `Simulator`
> WHERE DATE( `SimulatedTimeSet` ) = DATE(CURRENT_TIMESTAMP)"

Try FROM_UNIXTIME().

Have you read the manual section on date and time functions? There are
quite a few. You don't need to read hundreds of pages.

http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html

Baron

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)