How can I manage DATE fieldtype in PHP4 with Interbase? The problem is that i manage DATEs in format DDMMYYYY (spain) but Interbase manage it in MMDDYYYY format; so queries expected data in that format while i need it in other format. <% if(isset($action)) { ibase_timefmt("%d/%m/%Y",IBASE_DATE); $ibh=ibase_pconnect("localhost:/usr/interbase/databases/dbsite.gdb","SYSDBA" ,"masterkey"); if($action=="edit" && isset($CONTEXT) && isset($DATE)) { $sth=ibase_query($ibh,"SELECT newstext FROM news WHERE context='$CONTEXT' AND newsdate='$DATE';"); if(($row=ibase_fetch_row($sth))) { } } } %> Would you send me examples (small && smart) of that? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]