# system.db.runQuery

**URL:** <https://forum.inductiveautomation.com/t/system-db-runquery/18018>\
**Category:** General Discussion\
**Created:** [May 14, 2018, 2:51pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery/18018 "2018-05-14T14:51:16Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![aelgezabal](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@aelgezabal](https://forum.inductiveautomation.com/u/aelgezabal)\
**Post date:** [May 14, 2018, 2:51pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery/18018/1 "2018-05-14T14:51:16Z")

</div>

Hello  
I’m trying to calculate Cpk and sigma at a certain time. Specifically at 6:00. I have achieved this but once I want to read from the database it gives me errors

```python
import time
import system
from java.util import Calendar
cal = Calendar.getInstance()
# set year, month, day, hour, minute, second in one call

# This sets it to Feb 25th, 1:05:00 PM, 2010

#cal.set(2010, 1, 25, 13, 5, 0)
myDate = cal.getTime() 
cal.setTime(myDate)

cal.add(Calendar.HOUR, -24)

MyNewDate = cal.getTime()

ahoraHORA = system.db.dateFormat(myDate, "H:mm:ss")
AhoraDIA = system.db.dateFormat(myDate, "yyyy-MM-dd" )
Primera = '06:00:00'
Segunda = '05:59:59'
Ayer = system.db.dateFormat(MyNewDate, "yyyy-MM-dd" )

if (ahoraHORA > "14:00:00" and ahoraHORA < "18:15:00"):
	B1 = system.db.runQuery("Select B1 from Bisagras where t_stamp between '%s' '%s' AND '%s' '%s'" %(Ayer,Primera,AhoraDIA,Segunda))

```

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [May 14, 2018, 3:02pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery/18018/2 "2018-05-14T15:02:29Z")

</div>

Without knowing the error, it’s a bit more difficult, but I’d say there are too many single quotes around the datetimes in the query.

try:

```auto
Select B1 from Bisagras where t_stamp between '%s %s' AND '%s %s'

```

---

<div class="post-metadata">

**Author:** ![aelgezabal](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@aelgezabal](https://forum.inductiveautomation.com/u/aelgezabal)\
**Post date:** [May 14, 2018, 3:13pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery/18018/3 "2018-05-14T15:13:45Z")

</div>

Thank you I have done it and it does not give error.

---

<div class="post-metadata">

**Author:** ![aelgezabal](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@aelgezabal](https://forum.inductiveautomation.com/u/aelgezabal)\
**Post date:** [June 4, 2018, 8:53am UTC](https://forum.inductiveautomation.com/t/system-db-runquery/18018/4 "2018-06-04T08:53:19Z")

</div>

estoy haciendo una llamada a system.db.runQuery y el el query estoy poniendo “as” para poder salvar en un csv con encabezados cambiados y da un error en el as qu eno lo reconoce. Entiendo que es por como estoy escribiendolo.

Traceback (innermost last):

File “event:mouseClicked”, line 1, in ?

File “module:myfuncs”, line 212, in CSV

java.lang.Exception: Error executing system.db.runQuery(SELECT (t\_stamp as H\_t\_stamp from Bisagras where t\_stamp BETWEEN ‘2018-05-29 06:00:00’ AND ‘2018-06-30 05:59:59’) VALUES(K4), , )

Caused by: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: Gateway Error 500: Incorrect syntax near the keyword ‘as’.

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword ‘as’.

java.lang.Exception: java.lang.Exception: Error executing system.db.runQuery(SELECT (t\_stamp as H\_t\_stamp from Bisagras where t\_stamp BETWEEN ‘2018-05-29 06:00:00’ AND ‘2018-06-30 05:59:59’) VALUES(K4), , )

Ignition v7.2.6 (b128)  
Java: Sun Microsystems Inc. 1.6.0\_45

---

<div class="post-metadata">

**Author:** ![aelgezabal](https://avatars.discourse-cdn.com/v4/letter/a/f19dbf/32.png) [@aelgezabal](https://forum.inductiveautomation.com/u/aelgezabal)\
**Post date:** [June 4, 2018, 8:54am UTC](https://forum.inductiveautomation.com/t/system-db-runquery/18018/5 "2018-06-04T08:54:26Z")

</div>

Sorry, I put it in English

I’m making a call to system.db.runQuery and the query is putting “as” to be able to save in a csv with changed headers and it gives an error in the way it recognizes it. I understand that is how I am writing it.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [June 4, 2018, 11:36am UTC](https://forum.inductiveautomation.com/t/system-db-runquery/18018/6 "2018-06-04T11:36:24Z")

</div>

> [@](#):
>
> Error executing system.db.runQuery(SELECT (t\_stamp as H\_t\_stamp from Bisagras where t\_stamp BETWEEN '2018-05-29 06:00:00' AND '2018-06-30 05:59:59') **VALUES(K4), ,** )

The problem here is the VALUES portion of the query. SELECT does not use this.