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

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

Thanks!!

It works now.

Sucheta

> Sucheta Tripathy wrote:
>
>>Hi,
>>
>>Thanks. I can't provide sysdate here since I am uploading the release
>> date
>>of the database.
>>
>>
>>
> Sorry, I wasn't clear. I mean that you need to provide a date string in
> the same format as oracle's default format. The easiest way to find out
> the format is to envoke SYSDATE to view a sample date string. For example:
>
> SQL> select SYSDATE from DUAL;
>
> SYSDATE
> -------------------
> 2004-03-29 11:32:19
>
> States that I must put a fou digit year first, followed by month
> followed by month day. Even using the TO_DATE() function, oracle will
> not make the correct translation with your example:
>
> SQL> select to_date('15-DEC-03') from dual;
>
> TO_DATE('15-DEC-03'
> -------------------
> 0015-12-03 00:00:00
>
> But If I follow the convention of the default date format, to_date works:
>
> SQL> select to_date('2003-DEC-15') from dual;
>
> TO_DATE('2003-DEC-1
> -------------------
> 2003-12-15 00:00:00
>
> In order for your date format to work, you must supply the alternate
> format to the TO_DATE function:
>  SQL> select to_date('15-DEC-03', 'DD-MON-YY') from dual;
>
> TO_DATE('15-DEC-03'
> -------------------
> 2003-12-15 00:00:00
>
> Angel
>
>>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
>>>
>>>
>>>
>>
>>
>>
>>
>
>
>
> -------------------------------------------------------
> 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