亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標(biāo)題: perl如何傳遞時(shí)間變量給SQL語句 [打印本頁]

作者: fouter 時(shí)間: 2007-08-13 10:03
標(biāo)題: perl如何傳遞時(shí)間變量給SQL語句
ORACLE9 PERL5.8

my $newdate = $dbh ->prepare(qq{SELECT dretitle,drereference,dredate,launchtime FROM vir_podcast WHERE launchtime BETWEEN to_date('2007-8-10 13:00:01','YYYY-MM-DD HH24:MI:SS') AND to_date('2007-8-10 13:29:59','YYYY-MM-DD HH24:MI:SS') AND datasource = ?});
my $startime = "2007-8-10 00:00:01";
my $stoptime = "2007-8-10 23:59:59";
$newdate ->execute(22);

上面time字段是date型
用?號(hào)表示傳遞不了參數(shù)
請(qǐng)教怎樣將"2007-8-10 13:00:01" 這樣的時(shí)間用變量$startime,$stoptime進(jìn)行替換？

作者: galaxywar 時(shí)間: 2007-08-13 19:29
to_date( $startime, 'YYYY-MM-DD HH24:MI:SS')

歡迎光臨 Chinaunix (http://72891.cn/)