Date Help

From: Doermann, Jochen <jochen.doermann_at_doit.wisc.edu>
Date: 1997/06/05
Message-ID: <3397083C.D7FA203A_at_doit.wisc.edu>#1/1

This is a multi-part message in MIME format.
--------------A291AFAF6621ADE903D328F6

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

[Quoted] We're just getting our feet wet with Developer/2000 and Forms 4.5 (although it sometimes feels more like we're drowning). I need some help with date functions.

In other languages I'm used to functions like YEAR(a_date) that returns an integer date value. (Also MONTH(a_date) and DAY(a_date)). I can't find an equivalent in Oracle.

Ultimately, what I want to do, is break a date apart, manipulate the individual parts, and put it back together again. Any suggestions and/or code snippets?

TIA -- Jochen
--------------A291AFAF6621ADE903D328F6

Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Doermann, Jochen
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Doermann, Jochen
n:              Doermann;Jochen
org:            Univ of Wisconsin - Div of Info Technology
adr:            1210 W Dayton St - Rm 2237;;;Madison;WI;53706;USA
email;internet: jochen.doermann_at_doit.wisc.edu
tel;work:       (608) 263-3772
tel;fax:        (608) 263-8855

x-mozilla-cpt: ;0
x-mozilla-html: FALSE
end: vcard

--------------A291AFAF6621ADE903D328F6--
Received on Thu Jun 05 1997 - 00:00:00 CEST