Hi,
I have problem with inserting into BLOB field in Oracle 10:
insert into some_table(DESC) values ( '$txt')
The DESC field type is LONG RAW
The $txt variable contains large text, whitch is extracted from another
table field with same type.
When I read field DESC and print it, there is
Hello
you can not insert a lob this way.
Refer to the php manual pages at http://www.php.net/oci
And search for Example 3. Inserting data into a CLOB column
Vincent
-Original Message-
From: Rosen [mailto:[EMAIL PROTECTED]
Sent: jeudi 5 octobre 2006 14:43
To: php-db@lists.php.net
How to know diff between 2 date ?
tgl1 = 2006-10-05
tgl2 = 2006-10-06
result = 1 day
nandar
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Using SQL statement: datediff, example:
SELECT datediff( day, '2006-10-05', '2006-10-06' )
Hope it helps you ;-)
-
All-new Yahoo! Mail - Fire up a more powerful email and get things done faster.
Hey Nandar and all,
Check out this page:
http://www.developertutorials.com/tutorials/php/calculating-difference-between-dates-php-051018/page1.html
I found it by pluggin PHP difference between two dates into Google.
This one requires you have the date functions, including gregoriantojd()
in