
March 6th, 2013, 05:44 AM
|
|
Registered User
|
|
Join Date: Mar 2013
Posts: 2
Time spent in forums: 1 h 45 m 50 sec
Reputation Power: 0
|
|
|
I have not designed the database I am working with. I am using 'Priority 15's database.
the conversion is done with this statement : DATEADD(day,CURDATE/1440, '01/01/1988')
I will try to explain this again.
example:
There is a table called TableOne
There are 3 columns in TableOne - NAMEA, CURDATE, NAMEB
NAMEA is VARCHAR(20)
CURDATE is BIGINT datatype ( value 13163040 represents 10/01/2013 )
NAMEB is VARCHAR(20)
Now, if I wanted to display all columns from TableOne so SELECT * FROM TableOne
But, if I wanted to apply this: DATEADD(day,CURDATE/1440, '01/01/1988') to column CURDATE and then display all columns - then how do i do that?
display result would be :
NAMEA, CURDATE, NAMEB
but CURDATE column ( all values ) are not 13163040 but dd/mm/yyyy
|