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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 code..

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-02-16 : 07:31:04
eman writes "do you know the codes for getting the date?"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-02-16 : 07:33:49
Don't know if they're "codes" exactly:

http://www.amazon.com/exec/obidos/tg/detail/-/0964160307/qid=1076934690//ref=pd_ka_2/102-3504584-8825717?v=glance&s=books&n=507846
http://www.amazon.com/exec/obidos/tg/detail/-/0961317752/qid=1076934690//ref=pd_ka_3/102-3504584-8825717?v=glance&s=books&n=507846
http://www.amazon.com/exec/obidos/tg/detail/-/1403342431/qid=1076934690//ref=sr_8_xs_ap_i1_xgl14/102-3504584-8825717?v=glance&s=books&n=507846
http://www.amazon.com/exec/obidos/tg/detail/-/0914094157/qid=1076934690//ref=sr_8_xs_ap_i5_xgl14/102-3504584-8825717?v=glance&s=books&n=507846

And if you're just trying to hit on SQL Server:

SELECT GetDate()
Go to Top of Page

The Enigma
Posting Yak Master

179 Posts

Posted - 2004-02-16 : 07:34:15
Codes for getting date in sql server would be

select getdate()
Go to Top of Page

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2004-02-16 : 07:54:01
ROTF rob!!

OS
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2004-02-17 : 21:19:03
Man, I just ask her as gentle and nice as I can and maybe I get lucky...but sometime you gotta work her a little and the codes for that can be quite hard sometimes...

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"
Go to Top of Page

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2004-02-17 : 21:30:06
And the SQL Server repsonse...

"Is that an ISO format in your pocket or are you just happy to see me?"


DavidM

"SQL-3 is an abomination.."
Go to Top of Page
   

- Advertisement -