Home » Applications » Oracle Fusion Apps & E-Business Suite » sysdate (form 6i)
sysdate [message #476885] Mon, 27 September 2010 03:58 Go to next message
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
Senior Member
i designed the custom form
in that i want store sysdate to creation_date column
it store only date
i want to store date with time.....

i try as to set format mask as MM/DD/YYYY HH24:MI:SS to creation_date column

column data type is date

then on pre form i set as

forms_ddl('alter session set NLS_DATE_FORMAT = ''DD-MON-YYYY HH:MI:SS ''');

but still in db i am getting date only


how to resolve this..?
Re: sysdate [message #476891 is a reply to message #476885] Mon, 27 September 2010 04:25 Go to previous messageGo to next message
Littlefoot
Messages: 21688
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try to change item's datatype from DATE to DATETIME?
Re: sysdate [message #476907 is a reply to message #476891] Mon, 27 September 2010 05:57 Go to previous messageGo to next message
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
Senior Member
yes i alter column and set to datetime datatype still i am getting date only.........
Re: sysdate [message #476913 is a reply to message #476907] Mon, 27 September 2010 06:15 Go to previous messageGo to next message
Littlefoot
Messages: 21688
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Strange.

Quote:
but still in db i am getting date only

How did you check that? In SQL*Plus? Did you ALTER SESSION so that query returns both date and time?
Re: sysdate [message #476928 is a reply to message #476913] Mon, 27 September 2010 06:39 Go to previous messageGo to next message
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
Senior Member
if i write
select sysdate from dual
then it showing date and time both
but as i
select creation_date from custom_table
it show only date

now i change data type of column to datetime
still i get date in my custom table
Re: sysdate [message #476931 is a reply to message #476928] Mon, 27 September 2010 06:42 Go to previous messageGo to next message
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
Senior Member
i tried by alter seesion as well but still time not get store in custom table
Re: sysdate [message #476943 is a reply to message #476931] Mon, 27 September 2010 07:02 Go to previous messageGo to next message
Littlefoot
Messages: 21688
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't have Forms 6i so I did a test on my Forms 10g (9.0.4) connected to 10g XE database.

I created a table:
SQL> create table test (col date);
and used Data Block Wizard to create a default form. This is item's Data property palette:

/forum/fa/8301/0/

I ran the form and entered a value:

/forum/fa/8302/0/

Then I saved changes and went to SQL*Plus:
SQL> alter session set nls_date_format = 'dd.mm.yyyy hh24:mi:ss';

Session altered.

SQL> select * from test;

COL
-------------------
30.09.2010 09:45:00

SQL>

It seems that everything is fine. I really wouldn't know what went wrong in your case (unless Forms version difference makes such a difference).
Re: sysdate [message #476971 is a reply to message #476885] Mon, 27 September 2010 09:51 Go to previous messageGo to next message
eric62
Messages: 24
Registered: January 2009
Junior Member
Hello.

Do you use FND_STANDARD.SET_WHO ?

Re: sysdate [message #477024 is a reply to message #476971] Tue, 28 September 2010 00:06 Go to previous messageGo to next message
lokeshsurana
Messages: 212
Registered: April 2010
Location: India
Senior Member
@eric62
no i am not using that...
because the form design in 6i and same form will working on oracle apps server as well as chinab server so
on other server it fails
Re: sysdate [message #477654 is a reply to message #476885] Sun, 03 October 2010 02:05 Go to previous messageGo to next message
aheli
Messages: 10
Registered: August 2008
Location: India
Junior Member
Go to the Property of the field in the customized form in Forms 6i -> Change Datatype of the Field from Date to Datetime and then give the Date Format.
then run the form and it will insert Date as your desired format.
Re: sysdate [message #477657 is a reply to message #477654] Sun, 03 October 2010 02:37 Go to previous message
Littlefoot
Messages: 21688
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, that was the very first suggestion here (which, as it appears, didn't help). Any other idea, perhaps?
Previous Topic: HR Person API Update
Next Topic: Payables transfer to GL
Goto Forum:
  


Current Time: Sat Sep 25 19:11:30 CDT 2021