i don't know what kind of database u r using?
What is the result u r getting , "if u say select * from transaction"
in SQL(outside)/SQL*Plus(oracle).
If it is Oracle u can set NLS_DATE_FORMAT in init.ora file.
>Importance: high
>X-Priority: 1
>MIME-Version: 1.0
>Date: Sun, 17 Oct 1999 18:38:05 +0530
>From: RAHIMUNISA_N <[EMAIL PROTECTED]>
>Subject: Re: sysdate problem
>To: [EMAIL PROTECTED]
>
>hi,
>1. when i inserted data in transaction table i used trunc(sysdate). but
>while retrieving data it shows
>date plus time like "1999-10-13 00:00:00.0".
>my query is select * from transaction . i cant specify my date format.
>is there any way to resolve this problem . iam sending the package body
>and my java code. i want date to be displayed as "mm/dd/yyyy".
>---
>create or replace package body pkg_ebanc as
>
>function fun_transaction(accountno in varchar2) return c_gmm03trnsaction
>is
> c_trans c_gmm03trnsaction;
>begin
> open c_trans for
> select *
> from GMM03TRNSACTION
> where C001CUSTACCTNO like ltrim(rtrim(accountno));
> return c_trans;
>end fun_transaction;
>end pkg_ebanc;
>-----
>2. when i use an jpeg file for background
><body background=./images/pic.jpg>
>it says
>"servlet not found : images"
> how to solve this problem . i want all my images (jpeg,bmp,.. ) to be
>kept in images dir.
>-----------
>
Thank you
Saminathan Seerangan
510-574-7898
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
