Re: [Gusdev-gusdev] date format bug in submit row plugin

[Sucheta T. <su...@vb...>]

Hi,

Thanks. I can't provide sysdate here since I am uploading the release date
of the database.

Probably I have to look into the other options you suggested.

Sucheta

> This should be controlled by the oracle default date format. do "select
> sysdate from dual;" and you should get the default date format for
> inserting dates in your local oracle installation. Failing that, there
> is a TO_DATE() function in  oracle that we may be able to use in the
> object layer for any columsn that have DATE type, but this may not
> translate well to PostgreSQL.
>
> Angel
>
>
> Sucheta Tripathy wrote:
>
>>Hi,
>>
>>I just found that uploading data into sres.externaldatabaserelease has a
>>problem.
>>
>>The attribute release_date does not get the date format correctly. For
>>example if I provide the date like 15-DEC-03 it shows date like
>> 12/3/0015.
>>
>>Is there a fix available for this?
>>
>>Thanks
>>
>>Sucheta
>>
>>
>>
>>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>


-- 
Sucheta Tripathy
Virginia Bioinformatics Institute Phase-I
Washington street.
Virginia Tech.
Blacksburg,VA 24061-0447
phone:(540)231-8138
Fax:  (540) 231-2606