Forum Discussion

Dylan_Lemasson's avatar
Dylan_Lemasson
Frequent Visitor
6 years ago

Import an Azure table with a date restriction

Hi,   Is there a way to import an azure table with a date restriction ? It's possible with a SQL database and I'd like to do something similar : I just get a month of data in this case.   ...
Need Help
mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
6 years ago

Have you tried this?

 

SELECT * FROM  etatspasserelles
WHERE Timestamp  >= DATEADD(day,-30, getdate()) 
and   Timestamp  <= getdate()
Dylan_Lemasson's avatar
Dylan_Lemasson
Frequent Visitor
6 years ago

Thanks for your reply.

 

I can't do SQL request since it's an azure table (I guess ?) and I don't know where to enter a command if possible.

 

Cordialement,

Dylan