| Author |
Message |
    
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 21197
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Sunday, May 21, 2006 - 7:49 pm: |    |
 Kingsville.. |
Rrc
Pilla Bewarse
Username: Rrc
Post Number: 315
Registered: 04-2006
Posted From: 129.138.6.24
| | Posted on Sunday, May 21, 2006 - 7:49 pm: | |
ee vooruuuuuuuu |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 21194
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Sunday, May 21, 2006 - 7:37 pm: | |
 Texas A&M University |
Rrc
Pilla Bewarse
Username: Rrc
Post Number: 314
Registered: 04-2006
Posted From: 129.138.6.24
| | Posted on Sunday, May 21, 2006 - 7:34 pm: | |
 ee college |
Rrc
Pilla Bewarse
Username: Rrc
Post Number: 313
Registered: 04-2006
Posted From: 129.138.6.24
| | Posted on Sunday, May 21, 2006 - 7:33 pm: | |
nijamaaaaaaaaaaaaaaaaaaa |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 21192
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Sunday, May 21, 2006 - 7:32 pm: | |
 neti tudentsey repati temployeesu..nenu kooda monna Oct daaka tudentney.. |
Rrc
Pilla Bewarse
Username: Rrc
Post Number: 299
Registered: 04-2006
Posted From: 129.138.6.24
| | Posted on Sunday, May 21, 2006 - 6:55 pm: | |
nuvvu employeeeeeee vi kada ..
nenu tudentni.......... |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 21177
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Sunday, May 21, 2006 - 6:54 pm: | |
 mari telisinattu cuttings icchi naa meedha stone thrwing sesthaava.. |
Rrc
Pilla Bewarse
Username: Rrc
Post Number: 295
Registered: 04-2006
Posted From: 129.138.6.24
| | Posted on Sunday, May 21, 2006 - 6:48 pm: | |
naaku access radu |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 21175
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Sunday, May 21, 2006 - 6:47 pm: | |
 |
Rrc
Pilla Bewarse
Username: Rrc
Post Number: 291
Registered: 04-2006
Posted From: 129.138.6.24
| | Posted on Sunday, May 21, 2006 - 6:42 pm: | |
|
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 21155
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Sunday, May 21, 2006 - 11:59 am: | |
 good maama..naaku access asalu theliyadhu maama |
Jonny
Bewarse
Username: Jonny
Post Number: 1209
Registered: 04-2005
Posted From: 58.105.27.241
| | Posted on Sunday, May 21, 2006 - 11:29 am: | |
mamalu vachindi answer. thanks everyone.
badrio cheppadu
year(date()) vaadali. |
Jonny
Bewarse
Username: Jonny
Post Number: 1208
Registered: 04-2005
Posted From: 58.105.27.241
| | Posted on Sunday, May 21, 2006 - 10:00 am: | |
ACCESS mama |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1532
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Sunday, May 21, 2006 - 9:48 am: | |
Jonny .. mamma
MS SQLSERVER looo use GETDATE() and DATEDIFF function to
MYSQL loo NOW()- 365 using seeyee
Oracle loo SYSDATAE - 365 using seyeee |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 21145
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Sunday, May 21, 2006 - 9:48 am: | |
 PT maayya... |
Penkonda_tiger
Bewarse
Username: Penkonda_tiger
Post Number: 1531
Registered: 06-2005
Posted From: 62.234.167.180
| | Posted on Sunday, May 21, 2006 - 9:44 am: | |
<<ninnu adagatameti..sysdate automaticgaa theesukovaali kadhaa...inthaki database enti Oracle aa SQL serveraa...>>
kikiki GOCHI .. aaa quechtion Eppudaaa adegeeti .. DEFAULT ORACLE aneee SQL rastavaaa  |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 21144
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Sunday, May 21, 2006 - 9:35 am: | |
ninnu adagatameti..sysdate automaticgaa theesukovaali kadhaa...inthaki database enti Oracle aa SQL serveraa... |
Bangaraam
Pilla Bewarse
Username: Bangaraam
Post Number: 18
Registered: 05-2006
Posted From: 134.147.64.23
| | Posted on Sunday, May 21, 2006 - 9:31 am: | |
Jonny Mama, Samayaaniki Nayakudu Mama unte baavundedhi...athanu king Mama Sql lo |
Jonny
Bewarse
Username: Jonny
Post Number: 1207
Registered: 04-2005
Posted From: 58.105.27.241
| | Posted on Sunday, May 21, 2006 - 9:29 am: | |
mama trunc teesesi try cheste nanne adugutondi sysdate. dani anthata adhe ravali ante emi cheyyali? |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 21142
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Sunday, May 21, 2006 - 9:23 am: | |
aithe trunc theesesi try cheyyi maama... |
Jonny
Bewarse
Username: Jonny
Post Number: 1205
Registered: 04-2005
Posted From: 58.105.27.241
| | Posted on Sunday, May 21, 2006 - 9:16 am: | |
mama undefined identifier trunc ani vastondi |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 21140
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Sunday, May 21, 2006 - 9:10 am: | |
vaake |
Jonny
Bewarse
Username: Jonny
Post Number: 1204
Registered: 04-2005
Posted From: 58.105.27.241
| | Posted on Sunday, May 21, 2006 - 9:08 am: | |
thanks mama. nuvvu linelo undu kasepu. test chesi chepta vachindo ledo. |
Gochi
Bewarse ke Bewarse!
Username: Gochi
Post Number: 21137
Registered: 07-2004
Posted From: 71.234.232.47
| | Posted on Sunday, May 21, 2006 - 9:06 am: | |
maama..just system date choodalante
select sysdate from dual
ani raasi soodocchhu...
neeku one year back data kaavalante
select * from TABLENAME where trunc(DATE) >= trunc(sysdate-365) ani kodithe raavali..
table name lo neeku kaavalasina table peru,DATE place lo aa date item unna column name icheyyi..usualgaa begin_date,order_date alaa untaayi..lekapothe timestamp anna column untundemo...... |
Jonny
Bewarse
Username: Jonny
Post Number: 1203
Registered: 04-2005
Posted From: 58.105.27.241
| | Posted on Sunday, May 21, 2006 - 9:01 am: | |
mama sql lo chinna doubt.
system date ni ela access chestaru? naaku system date nunchi past one yearlo particular data kavali. so aa system date ni ela access cheyyali? alage oka sari access chesaka past one year loni records kavalante directga subtract cheyyacha? |
