Vertica SQL Functions

Moderator: NorbertKrupa

New Topic

35 topics

Topics

Replies

Views

Last post

MAPLOOKUP / MapJSONExtractor relative slowness

Last post by _pj_ « Fri Nov 09, 2018 3:07 pm

by _pj_ » Fri Nov 09, 2018 3:07 pm

0 Replies

92281 Views

Last post by _pj_
Fri Nov 09, 2018 3:07 pm
Calling SQL functions and not allowing to throw error.

Last post by fane89 « Wed Mar 21, 2018 9:13 am

by fane89 » Wed Mar 21, 2018 9:13 am

0 Replies

21354 Views

Last post by fane89
Wed Mar 21, 2018 9:13 am
REGEX_REPLACE or SUBSR to extract Twitter accounts from text

Last post by kryszczyn « Thu Nov 23, 2017 9:02 am

by kryszczyn » Thu Nov 23, 2017 9:02 am

0 Replies

20667 Views

Last post by kryszczyn
Thu Nov 23, 2017 9:02 am
Audit specific columns

Last post by JimKnicely « Fri Aug 04, 2017 7:16 pm
Replies: 3
by fane89 » Thu Aug 03, 2017 10:20 am

3 Replies

23405 Views

Last post by JimKnicely
Fri Aug 04, 2017 7:16 pm
TO_TIMESTAMP_TZ from string containing the UTC offset

Last post by JimKnicely « Tue Apr 11, 2017 7:48 pm
Replies: 4
by _pj_ » Mon Apr 10, 2017 1:45 pm

4 Replies

31176 Views

Last post by JimKnicely
Tue Apr 11, 2017 7:48 pm
Change Sysdate for tests purposes

Last post by Canarchiste « Fri Dec 02, 2016 8:22 am
Replies: 4
by Canarchiste » Wed Nov 16, 2016 11:16 am

4 Replies

27481 Views

Last post by Canarchiste
Fri Dec 02, 2016 8:22 am
How to analyze statistics on all tables in a schema?

Last post by JimKnicely « Thu Dec 01, 2016 8:16 pm
Replies: 1
by Brett » Thu Dec 01, 2016 8:01 pm

1 Replies

23176 Views

Last post by JimKnicely
Thu Dec 01, 2016 8:16 pm
Clear audit data?

Last post by NorbertKrupa « Sat Sep 24, 2016 9:08 pm
Replies: 2
by Julie » Tue Sep 20, 2016 9:01 pm

2 Replies

26395 Views

Last post by NorbertKrupa
Sat Sep 24, 2016 9:08 pm
Vertica User defined SQL function

Last post by JimKnicely « Thu Mar 31, 2016 1:07 am
Replies: 1
by rsaveetha » Tue Mar 29, 2016 1:31 pm

1 Replies

22275 Views

Last post by JimKnicely
Thu Mar 31, 2016 1:07 am
NUMTODSINTERVAL equivalent function in Vertica.

Last post by JimKnicely « Mon Dec 28, 2015 6:06 am
Replies: 1
by ksreekanth » Tue Nov 24, 2015 3:03 pm

1 Replies

22713 Views

Last post by JimKnicely
Mon Dec 28, 2015 6:06 am
TO_DATE('0730', 'hh24mi') in Vertica

Last post by ksreekanth « Tue Dec 15, 2015 1:19 pm
Replies: 2
by ksreekanth » Mon Dec 14, 2015 4:24 pm

2 Replies

20289 Views

Last post by ksreekanth
Tue Dec 15, 2015 1:19 pm
Use export_objects() to export more than one object?

Last post by Brett « Sun Sep 13, 2015 12:15 am
Replies: 2
by Brett » Fri Sep 11, 2015 3:07 pm

2 Replies

26618 Views

Last post by Brett
Sun Sep 13, 2015 12:15 am
Convert Hex to decimal on table column in vertica

Last post by id10t « Wed Jul 22, 2015 8:12 pm
Replies: 1
by santoshv82 » Wed Jul 22, 2015 5:37 pm

1 Replies

21245 Views

Last post by id10t
Wed Jul 22, 2015 8:12 pm
Get ADD_MONTH() function to not truncate time?

Last post by JimKnicely « Thu Jun 18, 2015 8:20 pm
Replies: 1
by piglet » Thu Jun 18, 2015 7:44 pm

1 Replies

18697 Views

Last post by JimKnicely
Thu Jun 18, 2015 8:20 pm
Is there an INT funtion in vertica?

Last post by usli06 « Tue Jun 16, 2015 2:58 am
Replies: 2
by usli06 » Sat Jun 13, 2015 9:07 pm

2 Replies

21005 Views

Last post by usli06
Tue Jun 16, 2015 2:58 am
trying to get view ddl using python

Last post by sldahlin « Wed Apr 29, 2015 4:06 pm
Replies: 2
by sldahlin » Tue Apr 28, 2015 10:05 pm

2 Replies

20269 Views

Last post by sldahlin
Wed Apr 29, 2015 4:06 pm
FUNCTION_DEFINITION column in USER_FUNCTIONS table too small!

Last post by NorbertKrupa « Thu Mar 12, 2015 4:17 pm
Replies: 1
by Josh » Thu Mar 12, 2015 11:25 am

1 Replies

18824 Views

Last post by NorbertKrupa
Thu Mar 12, 2015 4:17 pm
First day of the month function?

Last post by JimKnicely « Fri Mar 06, 2015 1:15 pm
Replies: 10
by beth » Tue Oct 08, 2013 8:30 pm
1

2
10 Replies

53083 Views

Last post by JimKnicely
Fri Mar 06, 2015 1:15 pm
now() <> sysdate

Last post by BoMBaY « Mon Nov 17, 2014 9:51 am
Replies: 6
by Brett » Thu Oct 30, 2014 2:24 am

6 Replies

33520 Views

Last post by BoMBaY
Mon Nov 17, 2014 9:51 am
Data encryption using hash function

Last post by rvramanan21 « Mon Jun 09, 2014 5:25 pm
Replies: 1
by rvramanan21 » Mon Jun 09, 2014 12:23 pm

1 Replies

20487 Views

Last post by rvramanan21
Mon Jun 09, 2014 5:25 pm
How to pull up an object definition

Last post by nnani « Mon Feb 17, 2014 11:00 am
Replies: 6
by Mrao » Tue Feb 11, 2014 2:31 pm

6 Replies

36053 Views

Last post by nnani
Mon Feb 17, 2014 11:00 am
A bug in the now function?

Last post by Idan « Tue Jan 21, 2014 4:07 pm
Replies: 2
by Idan » Tue Jan 21, 2014 3:28 pm

2 Replies

23205 Views

Last post by Idan
Tue Jan 21, 2014 4:07 pm
SOUNDEX Function

Last post by Josh « Thu Oct 31, 2013 10:25 pm
Replies: 2
by Josh » Wed Oct 30, 2013 2:28 pm

2 Replies

20523 Views

Last post by Josh
Thu Oct 31, 2013 10:25 pm
REPLICATE function?

Last post by JimKnicely « Thu Oct 31, 2013 1:42 pm
Replies: 2
by harryrundles » Wed Oct 30, 2013 1:58 pm

2 Replies

23125 Views

Last post by JimKnicely
Thu Oct 31, 2013 1:42 pm
SUBSTR() vs SUBSTRING()

Last post by bud « Sun Oct 27, 2013 4:46 pm
Replies: 2
by bud » Wed Oct 23, 2013 3:20 am

2 Replies

27911 Views

Last post by bud
Sun Oct 27, 2013 4:46 pm

New Topic

35 topics

Return to Board Index

Forum permissions

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum