use Date::Calc qw(:all);

[vintl]

how can i use the Today_and_Now() function for my INSERT stmt?
my stmt seems correct..but, it gives this error
DBD::mysql::st execute failed: You have an error in your SQL syntax near ''',NOW())' at line 1

$stmt = "INSERT INTO TB_LEAVE_RECORD VALUES(?,?,?,?,?,?,?,NOW())";
$sth = $dbh->prepare($stmt);
$sth->execute($D_EMPLOYEE_ID,$F_LEAVE_TYPE_ID,$F_DAY,$F_START_DATE,$F_END_DATE,$F_STATUS_ID,$F_REASON);
$sth->finish;

 

[tsdragon]

I can't see anything wrong with the sql statement, but you might try using now() instead of NOW(). I almost always use lowercase in my sql, and the now() function works for me (using MySQL).
Tracy Dryden
tracy@bydisn.com

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.

 

[tsdragon]

You also need to make sure that you have exactly as many values in the values list as there are fields in the table, and that they are in the exact same order as the fields in the table. Either that, or put a list of field names (in parens) before the values clause.
Tracy Dryden
tracy@bydisn.com

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.