Posted Fri, 20 Sep 2013 15:08:00 GMT by Portal Admin

Hello, I have a couple of SQL Server databases that I pull in by changing the host. I'm having a couple of issues.
1) My view errors out when opening due to some table name length issue where it can't find dbo/master4mat (where the full name is dbo/master4materials. It works fine when building but when reopening.

2) I can't seem to format a type TStmp 23 to MM/DD/YYYY. Any help would be appreciated.

Posted Thu, 16 Jun 2016 05:00:00 GMT by Portal Admin

Hi there,

We would need a joblog to assist with the SQL Server question. You can email that to [email protected].

As far as the timestamp question is concerned, if you perform the DATE function on the timestamp field, you will end up pulling the date out of the timestamp. You may need to do further formatting once that is done if the date is not in the format you need. DATE(field) --- field is your timestamp field.

Feel free to respond to this forum or contact us at [email protected]

Thanks

Originally Posted By jdaugherty

You must be signed in to post in this forum.