Home » Developer & Programmer » Forms » querying a particular record based on date function (oracle forms6i)
icon11.gif  querying a particular record based on date function [message #324468] Mon, 02 June 2008 10:52 Go to next message
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
Re: querying a particular record based on date function [message #324480 is a reply to message #324468] Mon, 02 June 2008 12:47 Go to previous messageGo to next message
Littlefoot
Messages: 20896
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'
Re: querying a particular record based on date function [message #324530 is a reply to message #324468] Mon, 02 June 2008 23:46 Go to previous message
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.
Previous Topic: How to convert date twice without using extra variables
Next Topic: to change source table at runtime
Goto Forum:
  


Current Time: Tue Dec 06 02:33:39 CST 2016

Total time taken to generate the page: 0.06675 seconds