QTP changes string returned from DB to date format

[Odette]

In a QTP script the first step is to get a table name from the database
If the query used in the script is executed in DataStudio it returns this value, which is correct : bill_0120150501

But when this code is executed in QTP the value assigned to the the array and variable is bill_0101/0/215

Anyone know how to prevent QTP / VBScript from doing this?

Code:

sql="select 'bill_01'||SUBSTR(bcy_next_run,1,4)||SUBSTR(bcy_next_run,6,2)||SUBSTR(bcy_next_run,9,2) current_bill_table from bcy_billing_cycle where bcy_bill_cycle = '01';"
testd = ExecuteQuery_Eppix(EppixDBUsername,EppixDBPassword,sql,EppixDBName)
current_bill_table= testd(0,0)

[babu123]

Code:

testd = double(ExecuteQuery_Eppix(EppixDBUsername,EppixDBPassword,sql,EppixDBName))

..... try this

[Odette]

Thank you for the reply, but no, that does not work
I need to understand why QTP / VB Script is changing the data in the first place