Yii Framework Forum: Date checking in mysql -- date and time duration - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Date checking in mysql -- date and time duration Rate Topic: -----

#1 User is offline   murugan 

  • Junior Member
  • Pip
  • Yii
  • Group: Members
  • Posts: 72
  • Joined: 12-June 09
  • Location:Chennai,India

Posted 07 February 2010 - 07:41 AM

Hi,
my table has
id,startdate,enddate,starttime,endtime,salelocation,imagename
both dates are in date type and starttime and endtime are in time type.
I want to check if my data consisting of startdate,starttime,enddate,endtime cannot be present in table and must be a valid date and time duration.
How to check this valid date and time interval?

my problem was
Duration of startdate with starttime and enddate with endtime can't be repeat or override or not inbetween in table,,
It must be a valid interval for sale a particular product.

I need mysql query to do this.

Thanks
Ramakrishnan t
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users