Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
paramu
Posting Yak Master
151 Posts |
 Posted - 2010-05-30 : 03:31:59
|
| HiWell & Thanks to Sql Team.I have a clarification please...The following query working fine..."Select Inward_no,space(50) as Inward_name from Inward_Master"Simillarly, I want to have like the below.."Select Inward_no,Datetime() as Inward_date from Inward_Master"so how to achieve this, like a extra datetime column with select query...Thanks To SQL TEAM By PARAMUParamu @ PARANTHAMAN |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-05-30 : 03:35:13
|
you want the current date ?Select Inward_no, getdate() as Inward_date from Inward_Master
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
paramu
Posting Yak Master
151 Posts |
Posted - 2010-05-30 : 10:37:04
|
| Thankyou KhtanAll of your advices are powerfulParamu @ PARANTHAMAN |
|
|
|
|
|
|
Select Query Extra Column - DateTime Field?