Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

ASP.NET Forum


You are currently viewing our ASP.NET Forum as a guest. Please register to participate.
Login


Tycoon Talk > Web Development and Programming Support > ASP.NET Forum > timestamp format

Reply
timestamp format
Old 11-23-2005, 06:08 AM timestamp format
numbenator's Avatar
Webmaster Talker

Posts: 516
Location: London
Trades: 0
Talkupation: numbenator is on a distinguished road
HI ,
Im trying to create a timestamp for an sql query.

my year, month and day are in numeric form

timeStamp1 = startyear & currentMonth & 01
05 01 01

MY problem is timestamp1 is coming out as

0511

How do I create this so timestamp is

050101


cheers

Steve
__________________

Please login or register to view this content. Registration is FREE
numbenator is offline
Reply With Quote
View Public Profile Visit numbenator's homepage!
 
 
Register now for full access!
Old 11-23-2005, 06:29 AM
Republikin's Avatar
Defies a Status

Posts: 3,189
Trades: 3
Talkupation: Republikin is a splendid one to beholdRepublikin is a splendid one to beholdRepublikin is a splendid one to beholdRepublikin is a splendid one to beholdRepublikin is a splendid one to beholdRepublikin is a splendid one to beholdRepublikin is a splendid one to behold
Try

Code:
timeStamp1 = DateSerial(startyear, currentMonth, 01)
__________________

Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE


Please login or register to view this content. Registration is FREE
Republikin is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to timestamp format
 
Previous Thread | Next Thread Tycoon Talk > Web Development and Programming Support > ASP.NET Forum > timestamp format

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.17178 seconds with 12 queries