Re: Help Inserting into PS_PERSON

Re: Help Inserting into PS_PERSON_COMMENT

[ Follow Ups ] [ Post Followup ] [ Message Board ]

Posted by [IP Address: 63.237.92.178] 'Invisible_Man' on August 31, 2001 at 12:00:35 EST:

In Reply to: Help Inserting into PS_PERSON_COMMENT posted by [IP Address: 63.237.92.178] 'LeAnne Smith' on August 31, 2001 at 08:40:58 EST:

: Hi all-
: I;m running into a error when i try to insert the Cmnt_dttm in the PS_PERSON_COMMENT table, for some reason i am not able to load in the cmnt_dttm which is of the format '4/21/1999 3:14:48 PM' and i tried sysdate, $sysdatetime and $asoftoday to insert in but no luck ,,, did anyone try this before, please let me know if you have any ideas on this
: thanks a lot-
: LeAnne

Can you do desc table_name, what is date format

Follow Ups:

Re: Help Inserting into PS_PERSON_COMMENT LeAnne Smith 12:03:22 8/31/01 EST (0)

Post a Followup

Name:
E-Mail:
Subject:
Message: : : Hi all- : : I;m running into a error when i try to insert the Cmnt_dttm in the PS_PERSON_COMMENT table, for some reason i am not able to load in the cmnt_dttm which is of the format '4/21/1999 3:14:48 PM' and i tried sysdate, $sysdatetime and $asoftoday to insert in but no luck ,,, did anyone try this before, please let me know if you have any ideas on this : : thanks a lot- : : LeAnne : Can you do desc table_name, what is date format