Time Of Day problem from WinCC Flex to SQL

userxyz

Member
Join Date
May 2002
Location
any
Posts
2,768
Hi,

I have a problem with the Time Of Day datatype.

On the HMI I have this:
The Date is shown in the format type date.
The Time is shown in the format type time.

format.JPG
The Tags Date are datatype Date.
The Tags Time are datatype Time_Of_Day.

ffd.jpg

cdes.JPG

Okay, with this script I write to an SQL database:

code.jpg

This is the result in the SQL Database table:
table.jpg

The Date is okay.

But the time is not okay. Even when I use varchar datatype as you can see. I've tried to use time, but that's not the solution because I then get a long decimal number...

It's a bit confusing that in DB's the Time datatype needs to be Time_Of_Day and on the HMI the format type needs to be time (else the date is vieuwed also. But for the SQL database I cannot find a solution to eliminate the date in the time column.

Anyone knows what to do ?

Thanks in advance,

Regards,
Gerry
 
Last edited:

Similar Topics

I'm trying to migrate a ProTool program to WinCC Flexible 2008 Advanced and when I open WinCC and say open a ProTool project, I get 2 errors. The...
Replies
5
Views
9,086
Dim i, a(10) For i = 0 To 9 Step 1 a(i) = SmartTags("visuf")(i) Next For i = 10 To 2 Step -1 a(i)= a(i-1) a(0)= SmartTags("valuetag")...
Replies
6
Views
5,468
Hello everyone, Info: I am using WinCC Flexible Runtime to log data to a SQL server. It is set up to log production values every minute from...
Replies
20
Views
11,314
Hi all, I have winncc flex 2008 project that I am working on. I have a MP377 panel connected via ethernet to a S7-300 which is working fine. I...
Replies
4
Views
9,351
Hi All, I am new here and from Down Under. My problem: I have WinCC flex 2008 SP1 HF1. After compiling I have the next error message: Internal...
Replies
5
Views
3,941
Back
Top Bottom