Index
2014-02-08 08:33 – Allen : [NF] sql version of ttod
2014-02-08 09:50 – Tom Slayton : RE: [NF] sql version of ttod
2014-02-10 09:58 – John Harvey : RE: [NF] sql version of ttod
Back to top
[NF] sql version of ttod

Author: Allen

Posted: 2014-02-08 08:33:41   Link

Hi gang

I have an SQL table (MSSQL) with datetime fields and I want to get records

that have the date in them. Like TtoD in VFP.

Is this doable?

Al

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/C248B300CF75435DB74F6F8E7C0B3AB8@gslredacer

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2014 Allen
Back to top
RE: [NF] sql version of ttod

Author: Tom Slayton

Posted: 2014-02-08 09:50:13   Link

Hi Allen,

Use

SELECT CONVERT(Date, Fb.MyColumnName) FROM FooBar Fb

Best,

Tom

-----Original Message-----

From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Allen

Sent: Saturday, February 08, 2014 9:34 AM

To: Profox

Subject: [NF] sql version of ttod

Hi gang

I have an SQL table (MSSQL) with datetime fields and I want to get records that have the date in them. Like TtoD in VFP.

Is this doable?

Al

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/a4ea99bb87be4988bf9cf97b3b8f141a@BLUPR05MB007.namprd05.prod.outlook.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2014 Tom Slayton
Back to top
RE: [NF] sql version of ttod

Author: John Harvey

Posted: 2014-02-10 09:58:56   Link

Do a google search on "Cast" and sql syntax.

John

-----Original Message-----

From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Allen

Sent: Saturday, February 08, 2014 7:34 AM

To: Profox

Subject: [NF] sql version of ttod

Hi gang

I have an SQL table (MSSQL) with datetime fields and I want to get records

that have the date in them. Like TtoD in VFP.

Is this doable?

Al

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/02c301cf2679$019453b0$04bcfb10$@shelbynet.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2014 John Harvey