Yes sir you are right console show the above result. but I post here the
insert query when above record inserted in database. there is right date
but when save it will auto convert to another date. please check it. here
is the insert query for above records. Please check it.
insert into
paymentList(voucherNumber,date1,shiftNoC,billTypeNo,companySubNo,veihHeadNo,tripEntryNoC,veihNumberNoC,ledgerGroupNoC,clBalanceLedgerGroupNoC,ledgerGroupNo1C,clBalanceLedgerGroupNo1C,amountMain,discountPer,discountFigure,ledgerGroupNo2C,ledgerGroupNo3C,amount1,roundOff,amount,totalAmount,paymentModeNo,chequeNumber,neftNumber,bankName,bankNoC,narrationA,userName,dateTimeDT,moduleRecordNo,nameNo)
values('177','2016-09-30',0,0,0,2,0,19,664,'1392000.00 Dr.',607,'1666400.00
Cr.',0,0,0,664,0,0,0,71000,0,1,'','','',0,'Hafta No. 5','123','2016-10-04
17:00:00.00',0,'177');
On Wednesday, November 23, 2016 at 3:45:19 AM UTC-8, Thomas Mueller Graf
wrote:
>
> Hi,
>
> Did you run this with the H2 Console tool?
>
> select "date1" from "paymentList" where "date1">='2017-01-01'
>
> date1
> 8016-08-31 00:00:00.0
> 9016-09-30 00:00:00.0
>
> So the result seems to be correct. Openoffice trucates the century.
>
> Regards,
> Thomas
>
>
>
> On Wed, Nov 23, 2016 at 12:20 PM, Mayur Bhatt <[email protected]
> <javascript:>> wrote:
>
>> When I Execute following query it's out is below
>>
>> Query : select * from paymentList where date1>='2017-01-01'
>>
>> Below screen shoots prove that the result is completely wrong. the all
>> records are < '2017-01-01' but query will show the result. I think this is
>> very serious bug in h2 database. I am using latest h2 database version.
>> 1.4.193
>> (latest)
>>
>> I attached the database file with this. mail. Please check it and give me
>> reply as soon as possible thanks in advance.
>>
>> Note that the if rewrite the date value then problem solved
>> automatically. Please refer that.
>>
>> User Name : Admin
>> Password : qs&softwareabcdef
>>
>>
>>
>>
>> <https://lh3.googleusercontent.com/-O5cjjI5rT_0/WDV5L1tKJSI/AAAAAAAAAs4/m40LGeZJ8jA6-gjAWKzhZu1x5sa1GFD8wCLcB/s1600/screen1.png>
>>
>> Av
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "H2 Database" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to [email protected] <javascript:>.
>> To post to this group, send email to [email protected]
>> <javascript:>.
>> Visit this group at https://groups.google.com/group/h2-database.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
