OraFAQ Forum: Forms » inserting Date value

Home » Developer & Programmer » Forms » inserting Date value

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

inserting Date value [message #133627]

Sat, 20 August 2005 05:16

manjuvasu
Messages: 22
Registered: May 2005

Junior Member

hi,
i have a date field of format mask dd-mm-yy in forms.while inserting it inserts to the current year as 20-aug-2005.it is correct.But i need to insert a value like 01-mar-1993 to database,as i give the input in form like 01-03-93.

how to do it.

Report message to a moderator

Re: inserting Date value [message #133630 is a reply to message #133627]

Sat, 20 August 2005 05:51

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Try 'DD-MM-RR' instead. But I strongly suggest you read on about the RR date format model before you do, so you'll know what it's about.
MHE

[Updated on: Sat, 20 August 2005 05:51]

Report message to a moderator

Re: inserting Date value [message #133746 is a reply to message #133627]

Mon, 22 August 2005 01:19

karthikraj
Messages: 27
Registered: August 2005

Junior Member

Hi,

Try using dd/mm/rrrr format instead.
Update back if it works out.
(i think this will definetly help u)

Raj

Report message to a moderator

Re: inserting Date value [message #133754 is a reply to message #133630]

Mon, 22 August 2005 02:08

manjuvasu
Messages: 22
Registered: May 2005

Junior Member

Thank u.

Report message to a moderator

Previous Topic:	Reg Right and Left Arrow Keys
Next Topic:	How to give the access of the buttons to selected user

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:42:15 CDT 2024