OraFAQ Forum: Forms » querying a particular record based on date function

Home » Developer & Programmer » Forms » querying a particular record based on date function (oracle forms6i)

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

querying a particular record based on date function [message #324468]

Mon, 02 June 2008 10:52

praveen_mcacbe
Messages: 5
Registered: March 2008
Location: bangalore

Junior Member

hi oracle gurus ,
I want your help regarding tiz issue .. i have a form containing details of emp record ... and i want to display the employess who joined last year in the form (its in tabular form design).... post your ideas and answers asap

with regards,
praveen kumar .h

Report message to a moderator

Re: querying a particular record based on date function [message #324480 is a reply to message #324468]

Mon, 02 June 2008 12:47

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

The principle is the same as in this recent thread; WHERE clause you enter would look like

to_char(:a, 'yyyy') = '2008'

Report message to a moderator

Re: querying a particular record based on date function [message #324530 is a reply to message #324468]

Mon, 02 June 2008 23:46

madhuri_madhav
Messages: 8
Registered: May 2008
Location: Hyderabad

Junior Member

Hi Praveen,

write the following code in the WHERE Clause of Data Block Property Pallete.

to_char(hiredate,'yyyy')=to_char(sysdate,'yyyy')-1

You will get the result.

Report message to a moderator

Previous Topic:	How to convert date twice without using extra variables
Next Topic:	to change source table at runtime

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 22:46:43 CST 2024