Re: Newbie DATESTAMP problem

2001-02-27 Thread Ken Tuck
ckier piece of code to get the correct results. Are you > trying to get the first day of the week? Haven't tested yours but if Monday > was the first day of the week and today is Tuesday then you would get > Tuesday last week, not Monday this week. > > - Original Message

Re: Newbie DATESTAMP problem

2001-02-26 Thread Rolf Hopkins
you trying to get the first day of the week? Haven't tested yours but if Monday was the first day of the week and today is Tuesday then you would get Tuesday last week, not Monday this week. - Original Message - From: "Ken Tuck" <[EMAIL PROTECTED]> To: "MySQL"

Newbie DATESTAMP problem

2001-02-26 Thread Ken Tuck
Hi All This is my first post of possibly many to this list. I am having a problem with trying to display time related content to a page. I initially setup the column with a 10 digit timestamp but found out that the date_sub function works with DATESTAMP data type. I only have 8 rows of test data