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]

Reply via email to