×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Time and Date stamp in WinCC

Time and Date stamp in WinCC

Time and Date stamp in WinCC

(OP)
Hi there,

Does anybody know what kind of datatype I should use in WinCC for inputting and outputting time and date values. For the date part I use an Active-X.
I need to transfer that data to an SQL server which needs the datatype Time/date stamp.
Or is there another way that my SQL server recognises my data.

Thanks

RE: Time and Date stamp in WinCC

Dear Fritzfrederix,
Could you pls explain the role of WinCC here? Should it submit the data to a database running on separate server?

And what date and time is it about? Simply system time of machine on which WinCC is running, or timestamp when a tag was updated, or something else?

RE: Time and Date stamp in WinCC

(OP)
Dear ipupkin,

I'm using WinCC (rel.6.0) to transfer data form WinCC to a SQL Server 2000 on a different computer over the network.
Some data can be inputted by an operator and other data is comming out of a PLC (Siemens S7-300).
We are producing Bales, the operators need to input the start date/time of the making of the bale and when the bale is finished they need to give in the end date/time.
WinCC doesn't support date/time stamps. So I send numeric data,which represents date/time, into a SQL and he needs to recognises it as date/time stamp.

Rudi

    

RE: Time and Date stamp in WinCC

Dear Rudi,

I'm absolutely agree that built-in timestamp datatype should be avoided. One vendor may use 1/jan/1900 as start point, another vendor - year 1980, this is too dependent.

I would transfer towards SQL server something like YyyyMmDdHhMmSs string. Almost sure MS SQL Server should be able to convert this into datetimestamp "on the fly".

Here's suitable forum to ask how to make MS SQL Server do this, I guess:

http://www.tek-tips.com/gthreadminder.cfm/lev2/4/lev3/27/pid/183

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources