Back to discussion

DATETIME Process?

Last post was 26 Feb 2008 at 09:18
db , sql server India
  • 13 years ago

    how can i store date format in SQL server in the format of "dd-MMM-yyyy"

    Report abuse
  • 13 years ago

    Basically, you can't (to my knowledge). DateTime or SmallDateTime are "types" in Sql Server that hold date time infomation.

    However Smiley Face

    You could create a DateTimeString field in your table (nchar(10)) whereby you could, on setting the datetime field either automatically or manually set the string field accordingly.

    Joe
     

    Report abuse
  • 13 years ago

    but is it possible to perform search by date order?

    Report abuse
  • 13 years ago

    You mean like:

    where <datetime> between date1 and date2 ?

    Joe 

    Report abuse
  • 13 years ago

    EXACTLY joe

    Report abuse
  • 13 years ago

     Yip - no problem... as far as I know, most databases can do search functionality wrapped around datetime (type) columns.

    Joe 

    Report abuse
  • 13 years ago

    Let me try upon this.......... THANKS JOE

    Report abuse

Post a reply

Enter your message below

Sign in or Join us (it's free).

SQL Server forum discussion

SQL Server tutorials

Quick links

Recent activity

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Web Development

Developer Jobs

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

Cancel
“Perl - The only language that looks the same before and after RSA encryption.” - Keith Bostic