retrieving date from sqlserver

[Girish]

I have date in this form stored in sqlserver 2004-01-29 10:24:41.000, when I
retrive it using formatdatetime vb function I get output as 12/30/99..

Any ideas please...

[Bob Barrows]

Girish wrote:

> I have date in this form stored in sqlserver 2004-01-29 10:24:41.000,

No. Unless you are storing it in a char or varchar column, it is NOT stored
in this form. Datetimes are stored as paired integers, the first containing
the number of days since the seed date, and the second containing the number
of milliseconds since midnight. All formatting is done by the client
application which displays the date

> when I retrive it using formatdatetime vb function I get output as
> 12/30/99..
>
> Any ideas please...

Show us the code.

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Bob Barrows]

Girish wrote:

> I have date in this form stored in sqlserver 2004-01-29 10:24:41.000,
> when I retrive it using formatdatetime vb function I get output as
> 12/30/99..
>
> Any ideas please...

Actually, ignore my last post: don't show us the code. Instead, go to
[url]www.aspfaq.com[/url] and search for "date". You will find several articles about
using dates.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Jeff Cochran]

On Thu, 29 Jan 2004 12:36:41 -0800, "Girish" <girishkiss@yahoo.com>
wrote:

>I have date in this form stored in sqlserver 2004-01-29 10:24:41.000, when I
>retrive it using formatdatetime vb function I get output as 12/30/99..

Is it a Date/Time data type in SQL? Or a text field? Are you sure
you have the correct FormatDateTime syntax? Show the code snippet,
and/or check:

[url]http://www.devguru.com/Technologies/vbscript/quickref/formatdatetime.html[/url]

Jeff

[Girish]

It is smalldatetime DATA TYPE, in one scenario I just want date and the
other both date and time in one shot, I followed your URL there you are
passing either date or time where as me I am passing both so.....

"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
news:403078e7.30692773@msnews.microsoft.com...

> On Thu, 29 Jan 2004 12:36:41 -0800, "Girish" <girishkiss@yahoo.com>
> wrote:
>

> >I have date in this form stored in sqlserver 2004-01-29 10:24:41.000,

when I

> >retrive it using formatdatetime vb function I get output as 12/30/99..

>
> Is it a Date/Time data type in SQL? Or a text field? Are you sure
> you have the correct FormatDateTime syntax? Show the code snippet,
> and/or check:
>
> [url]http://www.devguru.com/Technologies/vbscript/quickref/formatdatetime.html[/url]
>
> Jeff

[Jeff Cochran]

On Thu, 29 Jan 2004 14:02:42 -0800, "Girish" <girishkiss@yahoo.com>
wrote:

>It is smalldatetime DATA TYPE, in one scenario I just want date and the
>other both date and time in one shot, I followed your URL there you are
>passing either date or time where as me I am passing both so.....

So.... What?

You're not "passing" anything, you're retrieving a field in a record
from your database and formatting what you retrieve. Try something
like:

SelectedDate = SELECT MyDateField FROM TableWithDateField
MyDate = FormatDateTime(SelectedDate,0)
Response.Write MyDate

Or...

SelectedDate = SELECT MyDateField FROM TableWithDateField
MyDate = FormatDateTime(SelectedDate,2)
MyTime = FormatDateTime(SelectedDate,3)
Response.Write MyDate & " " & MyTime

You get the idea. You'll need to tweak the SQL for your own database
and connection of course.

And read the ASPFAQ items suggested by Ray for other trickery with
dates and times.

Jeff

>"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
>news:403078e7.30692773@msnews.microsoft.com...

>> On Thu, 29 Jan 2004 12:36:41 -0800, "Girish" <girishkiss@yahoo.com>
>> wrote:
>>

>> >I have date in this form stored in sqlserver 2004-01-29 10:24:41.000,

>when I

>> >retrive it using formatdatetime vb function I get output as 12/30/99..

>>
>> Is it a Date/Time data type in SQL? Or a text field? Are you sure
>> you have the correct FormatDateTime syntax? Show the code snippet,
>> and/or check:
>>
>> [url]http://www.devguru.com/Technologies/vbscript/quickref/formatdatetime.html[/url]
>>
>> Jeff

>

[John Blessing]

> SelectedDate = SELECT MyDateField FROM TableWithDateField

> MyDate = FormatDateTime(SelectedDate,0)
> Response.Write MyDate

Huh? And there i was thinking you might need a connection object or even a
recordset <g>

--
John Blessing

[url]http://www.LbeHelpdesk.com[/url] - Help Desk software priced to suit all
businesses
[url]http://www.free-helpdesk.com[/url] - Completely free help desk software !
[url]http://www.lbetoolbox.com[/url] - Remove Duplicates from MS Outlook
"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
news:4038863d.34106993@msnews.microsoft.com...

> On Thu, 29 Jan 2004 14:02:42 -0800, "Girish" <girishkiss@yahoo.com>
> wrote:
>

> >It is smalldatetime DATA TYPE, in one scenario I just want date and the
> >other both date and time in one shot, I followed your URL there you are
> >passing either date or time where as me I am passing both so.....

>
> So.... What?
>
> You're not "passing" anything, you're retrieving a field in a record
> from your database and formatting what you retrieve. Try something
> like:
>
> SelectedDate = SELECT MyDateField FROM TableWithDateField
> MyDate = FormatDateTime(SelectedDate,0)
> Response.Write MyDate
>
> Or...
>
> SelectedDate = SELECT MyDateField FROM TableWithDateField
> MyDate = FormatDateTime(SelectedDate,2)
> MyTime = FormatDateTime(SelectedDate,3)
> Response.Write MyDate & " " & MyTime
>
> You get the idea. You'll need to tweak the SQL for your own database
> and connection of course.
>
> And read the ASPFAQ items suggested by Ray for other trickery with
> dates and times.
>
> Jeff
>

> >"Jeff Cochran" <jcochran.nospam@naplesgov.com> wrote in message
> >news:403078e7.30692773@msnews.microsoft.com...

> >> On Thu, 29 Jan 2004 12:36:41 -0800, "Girish" <girishkiss@yahoo.com>
> >> wrote:
> >>
> >> >I have date in this form stored in sqlserver 2004-01-29 10:24:41.000,

> >when I

> >> >retrive it using formatdatetime vb function I get output as 12/30/99..
> >>
> >> Is it a Date/Time data type in SQL? Or a text field? Are you sure
> >> you have the correct FormatDateTime syntax? Show the code snippet,
> >> and/or check:
> >>
> >>

[url]http://www.devguru.com/Technologies/vbscript/quickref/formatdatetime.html[/url]

> >>
> >> Jeff

> >

>

[Jeff Cochran]

On Thu, 29 Jan 2004 22:50:17 -0000, "John Blessing"
<jb@**REMOVE**THIS**LbeHelpdesk.com> wrote:

>> SelectedDate = SELECT MyDateField FROM TableWithDateField
>> MyDate = FormatDateTime(SelectedDate,0)
>> Response.Write MyDate

>
>Huh? And there i was thinking you might need a connection object or even a
>recordset <g>

Probably the reason I posted this line as well:

> You get the idea. You'll need to tweak the SQL for your own database
> and connection of course.

If someone needs me to write the entire page I'll be happy to when I
get the time, or when I get my usually exhorbitant fee... :)

Jeff