[SOLVED] Convert Date (YY-M-D) and Time (char4) into Datetime field?

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4007098476

February 26, 2015, 12:07 PM

cs_source

[SOLVED] Convert Date (YY-M-D) and Time (char4) into Datetime field?

I am attempting to convert Date (YY-M-D) and Time (char4) into Datetime field as compute or define, i can't seem to find documentation on this.

I see alot of conversion the other way around though.

This message has been edited. Last edited by: <Kathryn Henning>,

WebFocus 8.02, SQL Server 2008r2

February 26, 2015, 12:41 PM

Tony A

Use DATECVT and potentially EDIT (for the time component) within the HINPUT function - DateTime functions.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

February 26, 2015, 01:30 PM

cs_source

I couldn't figure it using the functions you provided so i have found using other functions
Thanks!

WebFocus 8.02, SQL Server 2008r2