in reply to Re: sql datetime value with today
in thread sql datetime value with today

sql server is the database
(my $dd = $due_date) =~ s/-//g; $dd =~ /(\d{8})/; $past_due_date = ( $1 < $compare_date ) ? 'yes' : 'no';
where $dd and $compare_date both = 'yyyyddmm'