date as int
-
We bought some data and they have the date as an int.
How can I convert it into a datetime field?
-
Is it a genuine day-series integer, where +100 means +100 days, or is it integer storage of concatenated values, e.g. 20053101? If it looks like dates it is the latter.
Tim Wilkinson
"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant -
Can you put examples here
My Blog:
http://dineshasanka.spaces.live.com/ -
Could be a UNIX timestamp
-
SG,
We can help but we need to see some examples of the dates... as you can see from the posts above, there are a lot of possibilities...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
... of course, there are no possibilities when you don't respond to the people trying to help.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply