Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. This is the place for advice and discussions 1 1. Sign in to vote.
Hi, I have a Date table which may be called as a 'Date Dimension' table. Tuesday, August 6, PM. Search icon An illustration of a magnifying glass. User icon An illustration of a person's head and chest. Sign up Log in. Web icon An illustration of a computer application window Wayback Machine Texts icon An illustration of an open book. Books Video icon An illustration of two cells of a film strip. Video Audio icon An illustration of an audio speaker. Audio Software icon An illustration of a 3.
I know about ISO date. But does it really work? Yes I know it is a standard, but I must say I really don't have much faith in so-called standards anymore.
Besides, it's faster without varchar. What do you mean by "date serial"? Ah, you are from a VBA background, I take it. Add a comment. Active Oldest Votes. Improve this answer. Commenting here to help others in future as I was having trouble reconciling date serials and this answer helped me figure it out. The date serial in SQL is different to Excel by 1 day! Sign up or log in Sign up using Google.
Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.
0コメント