Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Convert Date (YY-M-D) and Time (char4) into Datetime field?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Convert Date (YY-M-D) and Time (char4) into Datetime field?
 Login/Join
 
Gold member
posted
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
 
Posts: 51 | Registered: November 30, 2012Reply With QuoteReport This Post
Expert
posted Hide Post
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.06 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5616 | Location: United Kingdom | Registered: April 08, 2004Reply With QuoteReport This Post
Gold member
posted Hide Post
I couldn't figure it using the functions you provided so i have found using other functions
Thanks!


WebFocus 8.02, SQL Server 2008r2
 
Posts: 51 | Registered: November 30, 2012Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Convert Date (YY-M-D) and Time (char4) into Datetime field?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.