frankm9639
Active member
- Joined
- Aug 24, 2006
- Messages
- 25
- Programming Experience
- 1-3
Can you tell me how this is done? I don't know if I should even do it this way. I am pulling data from the database into my dataset. The dates have the minutes, etc. still attached. I want to display a mm-ddm-yyyy on the screen. I thought of using an alias like this in the SQL:
----------------------------------------------------------
SELECT *, convert(nvarchar,PlanInception, 101) As PlanInceptionDate
FROM table1
----------------------------------------------------------
But then, how can I write this back to the database cause I'm now referencing the alias in the textbox? There has to be a better way to do this. Please help!
----------------------------------------------------------
SELECT *, convert(nvarchar,PlanInception, 101) As PlanInceptionDate
FROM table1
----------------------------------------------------------
But then, how can I write this back to the database cause I'm now referencing the alias in the textbox? There has to be a better way to do this. Please help!