Hi All,
What could be the equvalant line for the following line
floor(CAST( DATEDIFF( DAY, "dly_partcpnt_dim"."brth_dt",convert(datetime, {d '2012-02-29'}) ) as REAL ) / 365.25).
Note :This is sql code . I want the same in vertica.
Please help me out .
Thanks in advance ,
Malar
Search found 23 matches
- Tue Jun 18, 2013 11:34 am
- Forum: Vertica SQL Functions
- Topic: Convert datetime to real
- Replies: 3
- Views: 7870
- Wed Jun 05, 2013 11:07 am
- Forum: Vertica SQL
- Topic: Looping statements in Vertica
- Replies: 1
- Views: 8437
Looping statements in Vertica
Hi All,
Do we have looping statements in vertica like (for, while, do while).
If so , syntax and all is similar sql ?
Thnaks in Advance!!!
Malar
Do we have looping statements in vertica like (for, while, do while).
If so , syntax and all is similar sql ?
Thnaks in Advance!!!
Malar
- Tue Apr 09, 2013 7:25 am
- Forum: Vertica Migration
- Topic: Migrating data from sysbase to vertica
- Replies: 1
- Views: 15217
Migrating data from sysbase to vertica
Hi ,
I just want to know, can we migrate data from sysbase to vertica with out using any ETL tool.
Thanks,
Malar
I just want to know, can we migrate data from sysbase to vertica with out using any ETL tool.
Thanks,
Malar
- Fri Feb 22, 2013 11:18 am
- Forum: Vertica SQL
- Topic: preventing record from dupilcation
- Replies: 2
- Views: 9223
preventing record from dupilcation
Hi All, In a table for example Employee_table , empid is set as primarykey. When i insert duplicate records it is accepting the records. sample data: empid empname 101 A 101 B But when we take this records in joining tables it is voilating. I just want to get the error message when i insert data to ...
- Tue Feb 19, 2013 12:13 pm
- Forum: Vertica Migration
- Topic: migrating schema form oracle to vertica
- Replies: 2
- Views: 23233
migrating schema form oracle to vertica
Hi ,
Can anybody help me out to do the following thing .
1.How to migrate a schema or tables from oracle to vertica.
thanks,
Malar
Can anybody help me out to do the following thing .
1.How to migrate a schema or tables from oracle to vertica.
thanks,
Malar
- Mon Feb 18, 2013 1:45 pm
- Forum: Vertica SQL
- Topic: How to implement c++ add & substraction functions in vertica
- Replies: 2
- Views: 6192
Re: How to implement c++ add & substraction functions in ver
Hi ,
Yes that is what i wanted to do.Thanks for the solution .
Thanks,
Malar
Yes that is what i wanted to do.Thanks for the solution .
Thanks,
Malar
- Fri Feb 15, 2013 7:35 am
- Forum: Vertica SQL
- Topic: How to implement c++ add & substraction functions in vertica
- Replies: 2
- Views: 6192
How to implement c++ add & substraction functions in vertica
Hi All,
I want to implement c++ add & substraction concepts using a single library in vertica.
Please help me out to find the solution for this .
Thanks .
Malar
I want to implement c++ add & substraction concepts using a single library in vertica.
Please help me out to find the solution for this .
Thanks .
Malar