| Subject | SQL error conversion from string |
|---|---|
| Author | Peter Ypenburg |
| Post date | 2005-05-24T16:10:10Z |
Hi All,
When I run the following SQL I get an error, what am I doing wrong?
select cast(cast('05/24/2005' as date) as int)
from RDB$DATABASE
I am trying to get the Julian date from a date string '05/24/2005' which is
38496.
The error is: conversion error from string "24-MAY-2005"
Peter Ypenburg
When I run the following SQL I get an error, what am I doing wrong?
select cast(cast('05/24/2005' as date) as int)
from RDB$DATABASE
I am trying to get the Julian date from a date string '05/24/2005' which is
38496.
The error is: conversion error from string "24-MAY-2005"
Peter Ypenburg