Re: Date Functions

From: Lee Fesperman <firstsql_at_ix.netcom.com>
Date: Sun, 16 Feb 2003 23:51:52 -0800
Message-ID: <3E509498.475D@ix.netcom.com>

--B wrote:
>
> Hi,
>
> I have a date column having value like '1/1/1900 2:30:00 PM'.
> Is there an easy way to get time in 24hr scale using some functions, for
> above example it should return '14:30'?

For Java 'methods', check java.text.SimpleDateFormat. For SQL functions, check your DBMS vendor; there are no standard SQL Functions for formatting dates.

-- 
Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS  (http://www.firstsql.com)

Received on Mon Feb 17 2003 - 01:51:52 CST