I'm writing a SQL function that will be called in a large SQL batch after data has been loaded into Vertica. I need to check whether or not a string field is a date. But when I try val::Timestamp or TO_Timestamp(val) or TO_TimeStamp_TZ(val), an ERROR is returned. Is there a way to validate a date instead of receiving a cast error?
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.