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

50803 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

12314 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

11194 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

15127 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

19451 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

18284 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

15519 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

14735 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

15501 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

17222 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

14771 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

18621 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

13987 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

12566 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

13806 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

13910 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

12333 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

38738 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

24143 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

13072 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

22785 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

13479 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

13923 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

14184 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

17232 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