Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maeron
Starting Member
2 Posts |
 Posted - 2013-12-12 : 14:57:39
|
| Hi,I have a column with UNIX timestamp (i.e 1336963597)How can I get this value visible as a normal dateformat in a Report?I have tried expression like =CDate(Fields!timestamp.Value) but then the value becomes "#Error".What can I do to get it in 2013-03-10 22:43 format? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-12-12 : 16:08:05
|
| You'll need to do a conversion. Can you use the DateAdd function in SSRS? It's easy to convert in T-SQL, but since this is a presentation layer issue it should be handled by the report.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
maeron
Starting Member
2 Posts |
Posted - 2013-12-13 : 01:43:33
|
| If I try this. =DateAdd("ss","1970-01-01 00:00:00", Fields!timestamp.Value)I get an error |
|
|
|
|
|
|
Reporting Studio and Unix Timestamp