caparing date problem

I have a table which include the fields activity_start_date and
activity_end_date
the problem is that i dnt want to insert any record in the table id
activity_end_date is before the activity_start_date

WHAT????? Thismakes no sense at all!
jasvaran wrote:
> I have a table which include the fields activity_start_date and
> activity_end_date
Fine.

> the problem is that i dnt want to insert any record in the table id
OK so don't insert one.

> activity_end_date is before the activity_start_date
You're a time traveller right?

Care to have another go at asking this question?

jasvaran wrote:
> I have a table which include the fields activity_start_date and
> activity_end_date
> the problem is that i dnt want to insert any record in the table id
> activity_end_date is before the activity_start_date

Compare the dates programatically, and do not call insert if the logic
returns false. This should be possible in any programming language. As
far as SQL syntax goes, there is no where clause in an insert
statement.

-cheers,
Manish