String to date

Question

Question

Thembelani Mlalazi · Mar 12, 2019

I am trying to convert a string to date but can not get it to work I have function that I would like to take in a date string and covert it to date object

here is the ezample so far can not get it to work any help appreciated

set p="12/03/2019"
 
w $System.SQL.TODATE(p,"YYYY-MM-DD")
 
<ILLEGAL VALUE>todate+32^%qarfunc

if I try this still get the wrong value returned

set p="12/03/2019" 
w $ZDATE(p,3)
1841-01-12

Discussion (6)2

Log in or sign up to continue

Ponnumani Gurusamy · Mar 12, 2019

Hi Thembelani,

First we convert date to horolog.

set p="12/03/2019"

set horval=$zdateh(p) //now we got horolog value is 65350

After that , we use $zdate function and convert the date format.

w $zdate(horval,3) // now we got 2019-12-03

Thanks,

Ponnumani G

1 0

score 1 · Answer 1 · 2019-03-12T05:26:10-04:00

plain variables don't really have a type, so it's worth knowing what you want to use your date for (storing as %Date, %PosixTime, %Timestamp,...). If you're starting from a string and want to convert to IRIS' internal date format, use the $zdateh() function and use 4 as the second argument for European date format. See the docs for that function for more info.

score 1 · Answer 2 · 2019-03-12T05:36:18-04:00

Thanks this is what I am trying to do

Method StringToDate(pd As %String) As %Date
{
        #dim theDate as %Date
        
        SET theDate =$zdateh(pd,4)
        
        
        w $ZDate(theDate,3)
        QUIT
}

score 0 · Answer 3 · 2019-03-12T06:50:02-04:00

If you need to reorder a given set of characters (as above, from "12/03/2019" to "2019-03-12") then the $translate(...) function, used in "backward-mode" is your best friend.

set p="12/03/2019"
write $tr("abcd-ef-gh","ef/gh/abcd",p) --> 2019-12-03

Your gain: 50% of speed.

Nota bene

(1) $translate(inputdata, fromChars, toChars) --> outputdata
(2) $translate(toSequence, fromSequence, inputdata) --> outputdata

Where (1) is the Forward-Mode (the regular usage) and (2) the Backward-Mode

score 0 · Answer 4 · 2019-03-15T10:11:13-04:00

$System.SQL.TODATE() returns a %Date (+$Horolog) value.

The second argument to TODATE() describes the input format of the string-date value. In your example, you passed in a MM/DD/YYYY value but told TODATE the format was YYYY-MM-DD.

set p="12/03/2019"

write $System.SQL.TODATE(p,"DD/MM/YYYY")

Would have returned a logical %Date value

score 0 · Answer 5 · 2019-03-21T00:47:03-04:00

String date = "12/03/2019"; SimpleDateFormat sdt = new SimpleDateFormat("dd-MM-YYYY"); Date result = sdt.parse(date); System.out.println(result);