search

sdf-labs / sql-functions

8 stars 1 forks source link

Describe the feature... #78

Open dbartley2-wiq opened 2 months ago

dbartley2-wiq commented 2 months ago 
select 
  greatest(current_timestamp(), timestamp_sub(current_timestamp(), interval 1 day))
  as my_timestamp,

This works in BigQuery but fails in sdf.

error: SDF209: Failed to resolve function GREATEST: Argument type mismatch: actual: (timestamp, timestamp); candidates: ($1).