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

["Thornton, Robert" <RThornton@anteon.com>]

It looks like your date setting in the report is set to 'Mon DD YYYY HH:MIAM'
either reset that variable as below:


begin-sql
  alter session set nls_date_format = 'DD-Mon-YYYY'
end-sql


Or put an edit mask on the output as below: 


inventory.lastissuedate    &lastissue edit 'DD-MON-YYYY'


hope that helps 

Rob

-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of David Brawner
Sent: Friday, April 04, 2003 5:55 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] print date - date-format


Is your date stored in a character field, or a date field.

Your code converts a date to a character then back to a date???

Why not just,

        datetostr(inventory.lastissuedate, 'dd-Mon-yyyy')    &lastissue

It also seems like your mixing syntax from PL/SQL.  I didn't know SQR had a
"to_date" function.

Dave

-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of jessdb
Sent: Friday, April 04, 2003 2:20 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] print date - date-format


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

____________________________________________________________________
** Get your free E-Mail account at WWW.DIGITELONE.COM **

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




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