Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Discussions (General)
 Remind me again about dates...

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
AnonJr Posted - 13 August 2009 : 09:31:25
Its been one of those days... I may post about that later.

Remind me again why we are converting the date/time to a string and storing it as such...

I ask because I'm upgrading the online testing software where I work and in the process migrating to SQL Server 2005. I'm also tightening the integration with the forum, hence the question. As soon as I get the new structure planned out, I'm going to write the script to migrate the data from Access to SQL Server and if needed convert the date/time information.
2   L A T E S T    R E P L I E S    (Newest First)
AnonJr Posted - 13 August 2009 : 11:12:11
That's what I thought. Just checking - that first cup of coffee didn't really help...

Since I want to make use of functions like chkDate, UpdateLastHereDate, etc. I'll probably use the same format.
HuwR Posted - 13 August 2009 : 10:04:04
it is because different databases and ASP all treat datetime variables differently, it is therfire much safer to store the data as either text (Snitz does this) or as an integer.

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000 Version 3.4.07