sdc248
asked on
convert int to smalldatetime
Hi:
How do I convert an int to a smalldatetime?
The int has a format of yyyyMMddmmss. For example, 200707302345 means 7/30/2007 23:45.
Thanks.
How do I convert an int to a smalldatetime?
The int has a format of yyyyMMddmmss. For example, 200707302345 means 7/30/2007 23:45.
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oh, lahousden's solution works. Thanks a lot.
I think only if the input value is NULL (that is, was not set).
ASKER
ScottPletcher:
I did some more tests and found that your solution was right, it was me making a mistake when testing it. Now the points have been given to lahousden. Do you know any way I can give you the same amount of points as well? Sorry.
I did some more tests and found that your solution was right, it was me making a mistake when testing it. Now the points have been given to lahousden. Do you know any way I can give you the same amount of points as well? Sorry.
Thanks, I appreciate that.
Depends on how many pts the initial q was for? I think it was 150, but am not sure now. If it was, you can open a q with a title like "Points for ScottPletcher for Q_22732029". Remember, though, that according to EE rules, you cannot award more than 500 pts for any one q.
Depends on how many pts the initial q was for? I think it was 150, but am not sure now. If it was, you can open a q with a title like "Points for ScottPletcher for Q_22732029". Remember, though, that according to EE rules, you cannot award more than 500 pts for any one q.
ASKER
I have doubled the assigned points (125, now 250) and splited it so ScottPletcher can get the points he deserves.
Thanks a lot guys.
Thanks a lot guys.
ASKER