|
Home > Archive > ASE Database forum > December 2005 > SQL SYNTAX!!!! Need HELP
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL SYNTAX!!!! Need HELP
|
|
|
| Dear all gurus,
I would like to enquiries wat is below sql syntax perform:
(convert(varchar(12)
, a.check_in_date, 100)) as check_in_date ? and wat is the
100 means?
Ur help is most appreciate and thanks a lots.
---== Posted via the PFCGuide Web Newsreader ==---
http://www.mcse.ms/_newsgroups/group_list.asp
| |
| Mark A. Parsons 2005-12-23, 3:24 am |
| 100 is a date/time format style.
See the Reference Manual: Building Blocks, Chapter on T-SQL functions,
convert() for a list of valid styles.
Alternatively, if you have Rob's lil purple book, there's a chart of styles
on page 10.
KCC wrote:
> Dear all gurus,
>
> I would like to enquiries wat is below sql syntax perform:
> (convert(varchar(12)
, a.check_in_date, 100)) as check_in_date ? and wat is the
> 100 means?
>
> Ur help is most appreciate and thanks a lots.
>
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.mcse.ms/_newsgroups/group_list.asp
| |
| A Cornell 2005-12-23, 11:24 am |
| It's the date conversion format check table 11-13 in sybooks of the
Transact-SQL Users Guide
0 or 100 Default mon dd yyyy hh:mm AM (or PM)
"KCC" <database_baby@yahoo.com> wrote in message
news:43ab6ee6$1@foru
ms-2-dub...
> Dear all gurus,
>
> I would like to enquiries wat is below sql syntax perform:
> (convert(varchar(12)
, a.check_in_date, 100)) as check_in_date ? and wat is
> the
> 100 means?
>
> Ur help is most appreciate and thanks a lots.
>
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.mcse.ms/_newsgroups/group_list.asp
| |
| Will Banta 2005-12-23, 1:24 pm |
| KCC wrote:
> Dear all gurus,
>
> I would like to enquiries wat is below sql syntax perform:
> (convert(varchar(12)
, a.check_in_date, 100)) as check_in_date ?
this converts a date to varchar
and wat is the
> 100 means?
This is a format which corresponds to mmm dd yyyy h:ss AM/PM, or
something close
>
> Ur help is most appreciate and thanks a lots.
>
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.mcse.ms/_newsgroups/group_list.asp
|
|
|
|
|