Comparing to null queries

[Mike Rykowski]

Hello,

I have a query:

select * from table where del != 1;

Let's assume that I have a record where del is null (del is a single
character field).

In version 3.23.22-beta I get the record returned with the above query,
in version 4.1.10a I get nothing returned.

Did something change between these versions or is this a bug?  I
couldn't find anything specific to this on the archives.

TIA
-- 
Mike Rykowski
NU-IT Telecommunications and Network Services


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Convert historical dates from UTC

[Mike Rykowski]

Hello,
I have historical dates in datetime format and they are in UTC.  I'd like 
to convert them to localtime. Can this be done with mysql 3.23.22?  It 
looks like 4.1 can handle this, but I won't be upgrading in a while.

If not, does anyone know of a perl module that takes mysql formated 
datetime and does this?

TIA
-
Mike Rykowski
IT - Telecommunication and Network Services
(847) 467-7335
[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Convert historical dates from UTC

[Mike Rykowski]

At 10:28 AM 3/22/2005, [EMAIL PROTECTED] wrote:

What do you mean by historical? Are we talking 20th century dates or 
something BCE?
Dates that could be a couple of years old.
-
Mike Rykowski
IT - Telecommunication and Network Services
(847) 467-7335
[EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]