[SQL] time difference

2001-05-25 Thread Seema Noor
  i want to calculate the session time. my query is thisselect now() - '2001-05-19 12:09:00+5;it gives the difference in date and difference in time separately. if thecurrent time is greater than the second time then it gives simply theirdifference but i want to calcutate the session time f

[SQL] system time

2001-05-15 Thread Seema Noor
is there any function from which i can get system time? Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie ---(end of broadcast)--