convert sql timestamp to dateformat

[Former Member]

I have data from sql timestamp how can I convert this into dd/mm/yyy hh:mm:ss

Attach is the screenshot

[Former Member]

If you are on SQL Server, create a universe object as:

dateadd(s,table.timestampcolumn,'1970-01-01')

If you're on webi, use

=RelativeDate(ToDate("19700101";yyyyMMdd);[Timestamp]/86400)

[Former Member]

Hi Mark,

Thanks for the reply. Yes I apply the same in sql but I am getting the date correct but time is not coming correct. Because in application the time entered differ from sql when apply this dateadd function

Thanks,

Mohit

[Former Member]

That could be a timezone issue.