OraFAQ Forum: Forms » How to store date values? (merged)

Home » Developer & Programmer » Forms » How to store date values? (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to store date values? (merged) [message #235623]

Mon, 07 May 2007 08:04

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

Report message to a moderator

Re: I need help , please [message #235647 is a reply to message #235623]

Mon, 07 May 2007 10:04

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

Report message to a moderator

Re: I need help , please [message #235821 is a reply to message #235623]

Tue, 08 May 2007 01:51

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

Report message to a moderator

Re: I need help , please [message #235829 is a reply to message #235821]

Tue, 08 May 2007 02:03

dhrooj
Messages: 8
Registered: April 2007

Junior Member

hi

i use this way but it didnt work.

thanks

Report message to a moderator

Re: I need help , please [message #235832 is a reply to message #235623]

Tue, 08 May 2007 02:06

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

Report message to a moderator

Re: I need help , please [message #235836 is a reply to message #235832]

Tue, 08 May 2007 02:27

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) .

Report message to a moderator

Re: I need help , please [message #235869 is a reply to message #235836]

Tue, 08 May 2007 03:52

dhrooj
Messages: 8
Registered: April 2007

Junior Member

thanks to all

Report message to a moderator

How can Store date [message #235891 is a reply to message #235623]

Tue, 08 May 2007 05:09

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

Report message to a moderator

Re: How can Store date [message #235911 is a reply to message #235891]

Tue, 08 May 2007 06:54

Littlefoot
Messages: 21823
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')

Report message to a moderator

Re: How can Store date [message #235913 is a reply to message #235911]

Tue, 08 May 2007 07:00

Littlefoot
Messages: 21823
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.

Report message to a moderator

Previous Topic:	IP Address in forms10g
Next Topic:	How i can validate item in post query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 12:54:31 CST 2025