RE: Best method using SQL to combine date fields (day, month,year) -- MIDRANGE-L

Subject: RE: Best method using SQL to combine date fields (day, month,year)
From: rob@xxxxxxxxx
Date: Mon, 20 Oct 2008 14:46:53 -0400
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Never did a UDF?

How to write one in RPGLE (two separate authors, Buck and I)
http://faq.midrange.com/data/cache/185.html

Check the references at the bottom of the above site for doing one
straight in SPL (or, SQL Procedure Language).

Or download and check out Alan Campin's iDate available at:
http://www.think400.dk/downloads.htm

See also:
CREATE FUNCTION
QSYS2/SYSFUNCS
iNav Run SQL Scripts
iNav Database
http://store.midrange.com for various SQL books.

Rob Berendt

This mailing list archive is Copyright 1997-2026 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.