Home » Developer & Programmer » Forms » How to store date values? (merged)
How to store date values? (merged) [message #235623] Mon, 07 May 2007 08:04 Go to next message
dhrooj
Messages: 8
Registered: April 2007
Junior Member
helo to all,
i design table have tow coulmns datatype date in oracle

i need to save date in fields like this 08:30 or 15:30

using forms6i


any body can help me
please
Re: I need help , please [message #235647 is a reply to message #235623] Mon, 07 May 2007 10:04 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
you save date as default while accessing you can select this type of format.
AT
Re: I need help , please [message #235821 is a reply to message #235623] Tue, 08 May 2007 01:51 Go to previous messageGo to next message
imen_mr2004
Messages: 22
Registered: October 2006
Location: tunisia
Junior Member
hi
just try to use aformat mask to the field
HH:MM
Good luck
i'm not sure but try
Re: I need help , please [message #235829 is a reply to message #235821] Tue, 08 May 2007 02:03 Go to previous messageGo to next message
dhrooj
Messages: 8
Registered: April 2007
Junior Member
hi

i use this way but it didnt work.

thanks
Re: I need help , please [message #235832 is a reply to message #235623] Tue, 08 May 2007 02:06 Go to previous messageGo to next message
imen_mr2004
Messages: 22
Registered: October 2006
Location: tunisia
Junior Member
i just want to know why u don't want to save both the date and the time, it can be usefull to u may be
Re: I need help , please [message #235836 is a reply to message #235832] Tue, 08 May 2007 02:27 Go to previous messageGo to next message
NATVA
Messages: 9
Registered: May 2007
Junior Member
If you need to store in your format , you should create a column in a table with VARCHAR2 not DATE data type, then you can store like 08:30 .

else you should store as a full date like 'MM/DD/YYY HH:MI:SS'
and when you display the stored data ,select the date column like to_char(datecol,'HH:MI') in your report or forms ( use format mask for forms) .


Re: I need help , please [message #235869 is a reply to message #235836] Tue, 08 May 2007 03:52 Go to previous messageGo to next message
dhrooj
Messages: 8
Registered: April 2007
Junior Member
thanks to all
How can Store date [message #235891 is a reply to message #235623] Tue, 08 May 2007 05:09 Go to previous messageGo to next message
dhrooj
Messages: 8
Registered: April 2007
Junior Member
hi to all

i need to know how i can store date and time like this

25-07-2007 23:30:22

please

Re: How can Store date [message #235911 is a reply to message #235891] Tue, 08 May 2007 06:54 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You can not (unless you choose to store date values into a CHARACTER column, which would be a VERY BAD idea).

Dates are stored as ... well, dates, in Oracle's internal format unreadable to us, humans. But you'd use TO_CHAR function while displaying those values to users using appropriate date format mask: TO_CHAR(date_column, 'dd-mm-yyyy hh24:mi:ss')
Re: How can Store date [message #235913 is a reply to message #235911] Tue, 08 May 2007 07:00 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Please, do not open a new topic for the same problem. Continue discussion in existing one.
Previous Topic: IP Address in forms10g
Next Topic: How i can validate item in post query
Goto Forum:
  


Current Time: Fri Dec 09 13:41:47 CST 2016

Total time taken to generate the page: 0.14442 seconds