Re: SQL Statement

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: SriSamp (ssampath_at_sct.co.in)
Date: 05/13/04 

Date: Thu, 13 May 2004 18:07:43 +0530

The return type is a character. So you can store it into a character
variable and then use it to concatenate with other texts. Not sure if this
is what you meant below. 

-- 
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"kent_prokopy@hotmail.com" <anonymous@discussions.microsoft.com> wrote in
message news:34724A68-6184-4859-A776-116E6C33F187@microsoft.com...
> The statement you gave me is great, that you very much. Could you also
show me how to get it to return as text.
>
> '040513'
>
> or how to concatinate it into text.
>
> SELECT CONVERT (VARCHAR(10), GETDATE(), 12)
>
>      ----- SriSamp wrote: -----
>
>      SELECT CONVERT (VARCHAR(10), GETDATE(), 12)
>      -- 
>      HTH,
>      SriSamp
>      Please reply to the whole group only!
>      http://www32.brinkster.com/srisamp
>
>      "kent_prokopy@hotmail.com" <anonymous@discussions.microsoft.com>
wrote in
>      message news:5C53FD95-EAC9-4B5C-B47F-ED84321D01CB@microsoft.com...
>      > Could some one please show me how to format the GetDate Function to
>      display just the date so it looks like this...
>      > yymmdd
>      >> Thank you
>      > Kent Prokopy
>
>
>

Relevant Pages

  • Re: String Translation
    ... Well I know nothing of WMI but if you're getting a pathname in any kind of ... Concatenation will not spoil that unless you explicitly concatenate ... something with an incorrect character. ... important is when the compiler compiles with a string written in your source ...
    (microsoft.public.vc.language)
  • Re: Stripping out Alpha from a Field
    ... RevisionPrefix, BasePartNum, RevisionSuffix; and, has been said many times ... it is ALWAYS easier to concatenate multiple fields ... character between 0 and 9, it presumes that that character is the first ... I want to strip out all Alpha Characters from the Part ...
    (microsoft.public.access.queries)
  • Re: Group multiple items for a single condition
    ... If you defined your concatenate function so that it inserted a special ... character between each item in the list, you could then use edit replace in ... method only works when the merge link method is DDE; ... I now have the concatinated single string merging into my Word document. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Concatenating and Unconcatenating
    ... put some character between them that ... The actual contents will vary depending on what is ... What I would like to do is concatenate the 4 fields so that the user only ... has to pick once and then in different cells undo the concatenation so that ...
    (microsoft.public.excel)
  • Re: How to concatenate lines continued with ?
    ... I'm searching for the fastest and shortest way to ... concatenate lines continued with a backslash as ... : a last character. ...
    (comp.unix.shell)