Re: SQL UDF to Convert Today's Date to Dec(8,0) -- BPCS-L

Subject: Re: SQL UDF to Convert Today's Date to Dec(8,0)
From: rob@xxxxxxxxx
Date: Tue, 10 Nov 2015 14:50:11 -0500
List-archive: <http://archive.midrange.com/bpcs-l/>
List-help: <mailto:bpcs-l-request@midrange.com?subject=help>
List-id: BPCS ERP System <bpcs-l.midrange.com>
List-post: <mailto:bpcs-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/bpcs-l>, <mailto:bpcs-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/options/bpcs-l>, <mailto:bpcs-l-request@midrange.com?subject=unsubscribe>

There are a set of UDF's you can download to do this. I like Alan
Campin's idate. It is available at
http://www.think400.dk/downloads.htm

Your sample is pretty easy. Someone has to pass in a timestamp. Therefore
it already has to be valid. They can't pass you '2015-02-31-25.13.13'.
However, they can pass you a null value.

Validity checking, null values, etc, are all handled in idate. And it
costs nothing.

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.