sysdate [message #476885] |
Mon, 27 September 2010 03:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #476928 is a reply to message #476913] |
Mon, 27 September 2010 06:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #477024 is a reply to message #476971] |
Tue, 28 September 2010 00:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 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?
|
|
|