in reply to sql datetime value with today

How? What database?

Where is there a problem?

How about you spend more then 10 seconds composing your question?

Replies are listed 'Best First'.
Re^2: sql datetime value with today
by fionbarr (Friar) on Sep 19, 2014 at 19:11 UTC
    sql server is the database 
    (my $dd = $due_date) =~ s/-//g;
$dd =~ /(\d{8})/;
$past_due_date = ( $1 < $compare_date ) ? 'yes' : 'no';

    [download]
    where $dd and $compare_date both = 'yyyyddmm'
[reply]
[d/l]

In Section Seekers of Perl Wisdom