[sqr-users] RE: print date - date-format

["White, Denise" <DEWhite@vicr.com>]

Hi Jess,

Try:
to_char(inventory.lastissuedate,'dd-mon-yyyy')  &lastissue

By nesting the functions, you are first converting the date into the format you 
want (to_char), but then you are converting it back into its original date 
format (to_date).

Denise M. White
Sr. Software Engineer
Vicor 
--__--__--

Message: 1
From: "jessdb" <jessdb@digitelone.com>
To: sqr-users@sqrug.org
Date: Fri, 04 Apr 2003 15:20:17 +0800
Subject: [sqr-users] print date - date-format
Reply-To: sqr-users@sqrug.org

Hello...

Good day.

Every time I run my report which has the format below, the 
output also shows time. Connected using 'SQR ODBC for 
Oracle' Oracle 73... Win98. What should I do? I want to 
print an output like this 'dd-Mon-yyyy'. Please help.
  
to_date(to_char(inventory.lastissuedate,'dd-mon-yyyy'),'DD-MON-YYYY')   
&lastissue

[output]
Nov 19 1999 12:00AM

Thanks,
Jess

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users