What's new

Welcome to TheHiveForums

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?
Blue
Red
Green
Orange
Voilet
Slate
Dark

im trying to substract days from temp date column

ayeni22000

New member
Member
Joined
Nov 4, 2022
Messages
1
Reaction score
0
Points
1
im trying to substract 73 days from the 'today' column value below is what i have,


but it wont work. i got error msg "semanticexception[error]17980: operation is not supported. Table is not acid neither maprbjson.


How can i get this done pls


this is what i tried


create temp table myvv(taday date, rdf date, alert date)


insert into(today) select '2019-07-20;


update myvv set rdf = date_sub(today, 73)


column 'today' hold value date '2019-07-20' which ran successfully Im expecting: to substract 73 days from the 'today' column value


Expected result : column rdf , result 2019-05-08
 
Top Bottom