UNIX_TIMESTAMP function

2005-02-17 Thread Jerry Swanson 
How to select datetime using UNIX_TIMESTAMP excluding Saturday and Sunday?

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

Re: UNIX_TIMESTAMP function

2005-02-17 Thread Michael Dykman 
SELECT unix_timestamp(mydatetime), ... from mytable where 
DAYNAME(mydatetime) is not in('Saturday','Sunday');

On Thu, 2005-02-17 at 16:34, Jerry Swanson wrote:
 How to select datetime using UNIX_TIMESTAMP excluding Saturday and Sunday?
-- 
 - michael dykman
 - [EMAIL PROTECTED]


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